View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Barb is offline
external usenet poster
 
Posts: 70
Default go to the right worksheet

I have a class that is creating worksheets like
worksheetA1
worksheetA2
..
..
..
..
I want to keep each name in a column like A1 to A100
each time I open the workbook, it populates a listbox.
Is it possible to send all these worksheet name in a list box and when I
double click on one of the names it sends me directly to the right sheet???

thanks