View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ProjectUser ProjectUser is offline
external usenet poster
 
Posts: 2
Default drop-down lists and VBA code

I have about 50 worksheets in one workbook. Ive created a €śhomepage€ť that
has a drop-down list. In the drop-down list are values that represent each
of the 50 worksheets. Id like to create a module/function that will take me
to the appropriate worksheet when its worksheet title is selected in the
drop-down list.
Would someone be willing to share the code that would allow me to do what
Im looking to do?
Id greatly appreciate any assistance!