Combo Box in Dialogue Box

[mrowe]

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

 

[kkknie]

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