Phil,
The Worksheet_Change event perhaps ?

NickHK

"Defoes Right Boot" wrote in
message ...
I have a customer spreadsheet which brings up various things depending on
the
customer account number entered by the user (in cell F4.) Some of the
things
I need it to bring up depend on a macro being run based on the data in
that
cell. It doesn't need to run the macro while the cell is being edited but
when the Enter key is pressed. I can do it by using a button to click on
but
would be better to simply do it when cell F4 is updated.

Phil

"NickHK" wrote:

Phil,
Macros cannot run when a cell is being edited.
What are trying to achieve ?

NickHK

"Defoes Right Boot" wrote in
message ...
I need to make a macro run whenever cell F4 (strictly speaking the
merged
cells F4:F6) on the current worksheet is edited. I'm sure this must be
possible but can't find anything in the help files or online to tell
me
how...

Any ideas?

Thanks

Phil