Combo box to navigate to W/sheets

[fkristo]

Does anyone have any ideas on how to create a combo box or menu list to navigate to worksheets within the same workbook???

[gwhitfield]

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:

Worksheets(cboWorksheet.Value).Activate

if the value was not a valid value, you would get a "subscript out of range" error.