Placing macros within the IF condition
Perhaps this will do as you wish.........
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then
If Target.Value = 1 Then Call macroA
If Target.Value = 2 Then Call macroB
If Target.Value = 3 Then Call macroC
End If
End Sub
Vaya con Dios,
Chuck, CABGx3
"Sonia" wrote:
Hi...
I would like to run the below condition in excel.
If value of column A=1 then run macro A
If value of column A=2 then run macro B
If value of column A=3 then run macro C
Please help..
Bye for now
Sonia
|