Linking a combo box

[jimmeh]

Hello.

I'm looking for help with creating a combo box that will link to othe
worksheets.

Basically, what I am doing is making an information page for multipl
car companies. So what I'm looking at doing is having a combo box/dro
down list that if I choose, for example, "Ford", it will link to
worksheet with information about Ford, and if I choose "Toyota", i
will link to a separate worksheet with information about Toyota.

Is it possible to do this?

Any help is greatly appreciated

 

[Dave Peterson]

How about a worksheet that uses hyperlinks that point at those other sheets?

David McRitchie has a macro that will build that table of contents worksheet:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm