Combo Box in Dialogue Box

mrowe · Apr 30th, 2002, 09:11 AM

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 · Apr 30th, 2002, 10:20 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 09:11 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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

Apr 30th, 2002, 10:20 AM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	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