Frank Freese
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think that C2 is his Combo Box. And pressing the button moves you there.
ASKER
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.
It isn't a combobox, it's created via Data>Validation.
That should work fine though.
Or do you want/have a visible combobox?
That should work fine though.
Or do you want/have a visible combobox?
ASKER
ok...I use 2010 and save as 2003. Where's the list box in 2010?
ASKER
can the control be made visible without clicking on cell C2 and how does one modify your list box?
ASKER
a visible combo will be necessary
ASKER
if we can get that combo visible we'll be ok
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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...
You can right click the control and select Properties where you can set the Font, BackColour, ForeColour etc...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
missed clicking on design mode. I think I can take it from here...........many thanks
ASKER
thanks to all - I do appreciate it!
ASKER