Automatic Macro

  • Thread starter Thread starter k483
  • Start date Start date
K

k483

What's the syntax for executing a macro everytime a different cell gets
focus ?

thanks
 
HI,

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("C4:C4"), Target)
Is Nothing Then runMyMacro
End Sub

jeff
 
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

Auto-start macro 2
Syntax for stopping a Do Loop? 5
Macro Relative Cells 3
Saving a file automatically everytime it is closed 4
Copying & Pasting with recorded macros 9
Excell 2000 macro will not open file! 1
Run macros automatically-AutoFit 3
Run Macro If Cell have "x" value 0

Back
Top