View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default List sheet names in "pop-up" box for users to select

Steve pretended :
Hi Garry,

That's awesome, thanks! Is it a major code change to populate a combo box as
opposed to a list box? There are a bunch of sheets in this file, so viewing
them via a pulldown menu would help out a lot.

Thanks for your help!


Ha, ha! The only change I see, Steve, is replacing 'ListBox1' with
'ComboBox1'. This is done in one fell swoop using the Find/Replace
dialog (Ctrl+H)! Makes it a fairly trivial task...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc