Starting Marco

[elgringo56]

Is there a way to cause a certian macro to run when a cell is selected. Example, When Cell B2 is selected, either by direct selection or by tabbing, execute a macro named "ShowBusy"? This would be rather helpfull to me if anyone knows of a way. Thanks.......ElGringo

 

[Juan Pablo González]

Put this in the Worksheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$2" Then Call ShowBusy
End Sub