Results 1 to 2 of 2
2001-02-15, 09:26 #1fkristoGuest
Combo box to navigate to W/sheets
Does anyone have any ideas on how to create a combo box or menu list to navigate to worksheets within the same workbook???
2001-02-15, 10:58 #2
- Join Date
- Dec 2000
- Queanbeyan, New South Wales, Australia
- Thanked 0 Times in 0 Posts
Re: Combo box to navigate to W/sheets
A combo box on a worksheet or in a userform?
It's probably not important- the code would be similar in both instances.
If, for instance, you had a combobox on a worksheet (named cboWorkSheet for instance) populated with the worksheet names, you would have a "cboWorksheet_change" event with a statement like:
if the value was not a valid value, you would get a "subscript out of range" error.Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.