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!