Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Help
Ok, this is probably a dumb question but how do you set-up a combo box via
macrocode to select the choice you made in the box? I have a combo box and list built but I don't know how to write the macro to select the choice made in a list. Example: list choice Q5:Q10 "chart 1" or Q5 is actually sheet "chart 1" what would be the macro code for the selection made? Any help would be greatly appreciated! |
#2
|
|||
|
|||
Macro Help
Hello,
The following was originally built for a userform, but I think you could easily adapt it to work with a combobox on the worksheet. http://vbaexpress.com/kb/getarticle.php?kb_id=304 Hope it helps, -- Ken Puls www.officearticles.com "rpalmer4" wrote in message ... Ok, this is probably a dumb question but how do you set-up a combo box via macrocode to select the choice you made in the box? I have a combo box and list built but I don't know how to write the macro to select the choice made in a list. Example: list choice Q5:Q10 "chart 1" or Q5 is actually sheet "chart 1" what would be the macro code for the selection made? Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |