Macro Help

[rpalmer4]

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!

 

[Ken Puls]

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,