ComboBox with list of sheets in workbook

[alwayslrN]

I did a search here, but I think I am chosing the incorrect words for the search.

I know when I was searching for the web for somehthing else I saw this (see below) but for the life of me cannot remember where I saw it.

The thing that I saw as a spreadsheet which had a drop-down list object (combobox) that contained a list of the spreadsheets within a workbook. When I chose an item from the list it took me to that particular spreadsheet.

Has anyone seen VBA code that does that or know of a thread here that shows how to do that?

I have to apologize, as I was finishing this up I realized I did not look at the FAQ's.

FYI I will be using either Excel 2000 or 2002.

Thanks

 

[SkipVought]

Hi,

Read the sheet names into the ComboBox

dim ws as worksheet
for each ws in worksheets
  cbxYourCombo.Additem ws.name
next

Skip,

_[red][/red]