I have home-made XLA that should help: http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform

To have tabs alpha ordered, right click on arrows left of tabs list, and
select "Sort tabs"

To select a sheet:
Right-click on a cell and select "Select sheet"
You can type the beginning of the name: it will select corresponding entry
of the list.
To validate: press Enter or double-click on a name
To cancel: press Escape

HTH
--
AP


"keeper" a écrit dans le message de news:
...
Is there a way to use a drop down menu to select the tab and then go to
it?
I'm trying to make this worksheet as user friendly as possible and there
are
too many tabs to search through and being able to select it from a drop
down
menu would be easier.
Possible?