Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Combo Box in Dialogue Box

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

    Default

    HI,

    I'm after a solution to include a combo box in a dialogue box.

    The purpose is for a user to select a field from the combo box and it takes them to the worksheet in the workbook.

    i.e out of 5 choices they select "London", it takes them to the "London" worksheet.

    Can anyone help.
    Thanks

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

    Default

    The example below is for excel 2000 (which uses userforms instead of dialog sheets), but the principal is the same. Use the click event of the combobox to select the new sheet.

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

    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
  •