Hi
this sound more like your combo box tranfers the value as 'Text' value
and only after going in this cell Excel notices it's a number. So you
may check the formating of your combo box or esp. the values in your
combobox

--
Regards
Frank Kabel
Frankfurt, Germany


Jeremiah Lemay wrote:
The cell is linked to a cell in the spreadsheet.
When I choose an item from the combo box the new number is enter into
the cell ok. The problem is that the related protion of the line
graph drops to zero until I click in the cell. Once this is done
then the line graph updates.
I need the macro to do the updating for me. When users select the
cell the graph will update then.

Thanks for your reply.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!