Hi
why not simply link the combo Box to a cell?

--
Regards
Frank Kabel
Frankfurt, Germany

"Jerry" schrieb im Newsbeitrag
om...
I have been trying to right a macro to no avail.
I have a combo box on sheet one containing 5 items.
When the user selects one of the options it is to send
a specific number to another cell, which is then displayed
in a line graph.
Then the cell has to refresh automatically so that the graph updates.
Because Excel does not update automatically, if not
the graph does not update.

Nothing I've done seems to work. Searched hi and low on
the internet and help files.

Please Help.