View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
maijiuli maijiuli is offline
external usenet poster
 
Posts: 56
Default control toolbar combo box and command button

Dave or should I say Sir Peterson, you are a genious. I can't thank you
enough for this one.

MJ
--
Thank You!


"Dave Peterson" wrote:

Maybe you could use something like:
http://contextures.com/xlToolbar01.html

maijiuli wrote:

Hello,

I'm interested in using a combo box and command button from the control
toolbar. The combo box will contain the names of all the worksheets in this
file. This is done with a dynamic named range. The command button will act
like a "submit" button to take the user to the desired worksheet selected
from the combo box.

The names of the worksheets are like: Aetna, Blue Shield, Pacificare, etc.
Is there a way to do this?

Thanks in advance,

MJ
--
Thank You!


--

Dave Peterson