Lost Focus - Applying to cell
 

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

Lost Focus - Applying to cell
 

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

Lost Focus - Applying to cell
 

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