Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Dialogue Box Drop Down

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi.

    I want to include a combo box in a dialogue box that jumps to a one of 5 worksheets in the work book.

    Basicly when the select the name of the worksheet i.e "London" it takes them there.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mrowe

    Can you explain in detail what you really need old friend ?

    Email me if you need to

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Greenwood, SC
    Posts
    677
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Assuming your Dialog box is a userform...

    Private Sub ComboBox1_Click()
    Sheets(ComboBox1.Text).Select
    End Sub

    Private Sub UserForm_Initialize()

    For Each s In Sheets
    ComboBox1.AddItem s.Name
    Next
    ComboBox1.Text = ActiveSheet.Name

    End Sub

    You would also need to put something under ThisWorkbook like:

    Private Sub Workbook_Open()
    UserForm1.Show
    End Sub

    to get the dialog box to open when the workbook opens. If this doesn't answer your question, ask it again with more detail and I'll give it another try.

    K

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •