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.

<pre>
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "B2" Then ShowBusy
End Sub
</pre>

 

[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.

<pre>
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
</pre>