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.

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.

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!

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!

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.

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


When I make a selection with the combo box it enters the number into
the linked cell. The problem is after making the selection the line
graph that the cell is linked to drops to zero. But if I go into the
cell and out the number then registers and the line graph is updated
accordingly. So the macro needs to update or refresh the cell after
the selection is made by the user so the graphs reflects the proper
number automatically.