List sheet names in "pop-up" box for users to select
 

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!

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