Lost Focus - Applying to cell

  • Thread starter Thread starter Paul Silverman
  • Start date Start date
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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine which cell was populated 3
Problem Applying Formula to cell 2
Cell Lost Focus 1
Selection hides when Excel lost focus 2
UserForm - Setting focus to a CommandButton based on a Cell's contents 2
Change Cell focus base on value in first Cell 1
Both "And" & "Or" in one If Statement 2
Move cell focus in VBA 1

Back
Top