Help - with macro

[Jerry]

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.

 

[Frank Kabel]

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

 

[Bob Phillips]

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]

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)

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.

 

[Jeremiah Lemay]

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.

 

[Frank Kabel]

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