View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
matthiasmorath matthiasmorath is offline
external usenet poster
 
Posts: 1
Default open worksheet with a macro (combobox)


Hi, well as usual simple things you can't find in the user manual
I was looking forward to create a simple macro using a combobox
to select one of 100 worksheet in a workbook.

How can i open a worksheet is there any kind of command for doing so,
how can i put all worksheets into the combobox without programming, or
changing the code everytime (user creates a new worksheet for example)


Thank you very much

Matthias


--
matthiasmorath
------------------------------------------------------------------------
matthiasmorath's Profile: http://www.excelforum.com/member.php...o&userid=34970
View this thread: http://www.excelforum.com/showthread...hreadid=547071