View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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