Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Populate combo box in Excel

Experts,
How can one populate a combo box with the names of the spreadsheets in the workbook populating the combo box and then once selected go to that spreadsheet?  Do you use a form control or ActiveX control?
SOLUTION
Avatar of gtgloner
gtgloner
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Freese

ASKER

take a look at your example - I think something is missing - thanks
Avatar of ScriptAddict
I think that C2 is his Combo Box.  And pressing the button moves you there.  
ok..that'll get me what I need. Why is the combox not visible?
I actually used a list box, it was easier to write some VBA code to do what you wanted to do with that.
Avatar of Norie
Norie

It isn't a combobox, it's created via Data>Validation.

That should work fine though.

Or do you want/have a visible combobox?
ok...I use 2010 and save as 2003. Where's the list box in 2010?
can the control be made visible without clicking on cell C2 and how does one modify your list box?
a visible combo will be necessary
if we can get that combo visible we'll be ok
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hey...this looks good. I'll need to make a few cosmetic changes so now how did you do this?
What changes do you need to make?

You can right click the control and select Properties where you can set the Font, BackColour, ForeColour etc...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
when I right click on the control the property window become disabled - not sure why.
Are you sure you have design mode activiated?  It should be highlighted yellow if you have that active.
missed clicking on design mode. I think I can take it from here...........many thanks
thanks to all - I do appreciate it!