Lost Focus - Applying to cell

P

Paul Silverman

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
 
T

Trevor Shuttleworth

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
 
P

Paul Silverman

Thanks for your help. Much appreciated.

Paul

Trevor Shuttleworth said:
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
Click to expand...
 
Top