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!

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!