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

[Colo]

Hi ElGringo.
Right click on the sheet tab, select View Code and Please copy this into there.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  If Target.Address(0, 0) = "B2" Then ShowBusy

End Sub

[elgringo56]

Pretty fantastic. Does just what I want. Can I put more than one entry so that various cells can start various macros?
Again, Thanks a Million

[Colo]

Hi.
If you have various macros named "Shushi","Tenpura","Ninja".....
An easy way to execute more than one entry is to use "Select Case" method.

Here is a sample.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Count > 1 Then Exit Sub

    Select Case Target.Address(0, 0)

        Case "B2"

            Shushi

        Case "B3"

            tenpura

        Case "B4"

            ninja

    End Select

End Sub