Call a macro when a cell is selected

[Alpacino]

How do you run a macro if a cell is selected or values change??

Thanks

 

[pushkardey]

How do you run a macro if a cell is selected or values change??

Thanks

in VB Editor goto the project explorer(if you cant see project explorer press Crtl+R) the choose the worksheet you want use change option in and paste/call your macro within the following :

Private Sub Worksheet_Change(ByVal Target As Range)

call macro_name

End Sub

Hope this helps

 

[Alpacino]

How do i call the macro if e.g. cell H2 data validation value is changed??
Thank you

 

[pushkardey]

How do i call the macro if e.g. cell H2 data validation value is changed??
Thank you

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$2" Then
        Call Macro_Name
End If
End Sub

Hope this helps....