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!