Hi Folks,

I've written a subroutine which I want to run automatically when the user
enters data into, and then click off, cell A1.

Can someone please provide me with an example as to how this is done? I
suspect it's Lost Focus - any help is appreciated.

Thanks much,

Paul Silverman
Melbourne
Australia

Paul

you need to use either the Worksheet_Change or the Worksheet_SelectionChange
events in the Sheet Class module.

Test for the target cell being A1. Search the Google archives; you'll see
dozens of examples

Regards

Trevor


"Paul Silverman" wrote in message
...
Hi Folks,

I've written a subroutine which I want to run automatically when the user
enters data into, and then click off, cell A1.

Can someone please provide me with an example as to how this is done? I
suspect it's Lost Focus - any help is appreciated.

Thanks much,

Paul Silverman
Melbourne
Australia

Thanks for your help. Much appreciated.

Paul

"Trevor Shuttleworth" wrote in message
...
Paul

you need to use either the Worksheet_Change or the
Worksheet_SelectionChange
events in the Sheet Class module.

Test for the target cell being A1. Search the Google archives; you'll see
dozens of examples

Regards

Trevor


"Paul Silverman" wrote in message
...
Hi Folks,

I've written a subroutine which I want to run automatically when the
user
enters data into, and then click off, cell A1.

Can someone please provide me with an example as to how this is done? I
suspect it's Lost Focus - any help is appreciated.

Thanks much,

Paul Silverman
Melbourne
Australia