change event procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do you know how to adapt the code,

Private Sub Worksheet_Change(ByVal Target As Range)

to execute when one particular cell is changed rather than any cell in the
worksheet?
 
Ben,

To have it only look at cell A2:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$2" Then Exit Sub
....


HTH,
Bernie
MS Excel MVP
 
Private Sub Worksheet_Change(ByVal Target As Range)

if target.address= "$A$1" Then
'etc.
End If

End Sub
 
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

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Simple Copy Paste within Worksheet Change Event 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Run procedure in stored in module on worksheet change event 5
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Break points will be ignored in Excel 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Help with worksheet_change script 26

Back
Top