Placing macros within the IF condition

S

Sonia

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
 
B

Bob Phillips

You cannot run a macro in an IF Function if that macro tries to modify the
sheet or cells in any way. If it is a function that returns a result then
that is okay, simply

=IF(A1=1,Function1, IF(A2=2,Function2, etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
C

CLR

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
 
S

Sonia

The macro is not being used to modify the sheet. based on the value in Column
A the respective macro has to be run. ( the macro is to only open another
file ).
Please let me know which function I can use in the IF function to run the
macro.
 
B

Bob Phillips

As I said, if it is modifying the sheet or cells it cannot be called from a
worksheet function.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top