Cell Change Event

  • Thread starter Thread starter Edd
  • Start date Start date
No, not for a specific cell per se, but filtering to an individual cell is
quite easy to do. In the VBA editor, within the worksheet code window, click
the left-hand drop down and select Worksheet from the list; then click the
right-hand drop down and select Change from its list. Whenever any cell is
finished being edited, the Change event fires and the Target argument
contains a reference to the cell that was changed. Let's say you wanted to
run code whenever C3 was changed; you could do this...

If Target = Range("C3") Then
' Your code goes here
End If

Rick
 
The title line should read:

Private Sub Worksheet_Change(ByVal Target as Range)
 
Thank you Rick and JLGWhiz. That's what I ended up doing and it works
succesfully. I appreciate this forum and you guys..

Ed.
 
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

Cell content change Event 7
sheet event wait for another event? 6
Event when cursor changes cells, but no select(?) 2
Cell Background Color Change --> Change Event 5
Change event does not fire 3
Worksheet Change Event Triggering Multiple Times 2
Event triggered in Excel's cell by DDE 3
On change event for specific cells 2

Back
Top