What do you mean by the cell refreshing automatically?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jerry" wrote in message
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.