determine when the user moves to a difference cell

  • Thread starter Thread starter Sean Farrow
  • Start date Start date
S

Sean Farrow

Hi:
in excel how do I use the onworksheet change event? to determine then the
cellthe user is in has changed.
Do I have to implement all function for an event sink or canIjust implement
the functions I require, in this case I am using the AppEvents interface.
Any guidance apreciated.
Sean.
 
Put worksheet change event code on the worksheet code sheet you are
monitoring,
the following tracks cell A1 for changes....

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "A1 has changed"
End If
End Sub
 

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

Traversing the collumn of the active cell 5
difference between Value and Value2 and obtaining the value of a cell in excel xp and later 2
How to Determine When Calculations are Complete 3
Determining which Print Button was clicked 2
Set the "No Sounds" scheme for the default user profile 0
Apply Conditional formatting if cell contains formula 6
changing a color based on another color change 1
custom function - finding cell address 4

Back
Top