Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Placing macros within the IF condition
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Placing macros within the IF condition
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) "Sonia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Placing macros within the IF condition
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. "Bob Phillips" wrote: 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) "Sonia" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Placing macros within the IF condition
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) "Sonia" wrote in message ... 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. "Bob Phillips" wrote: 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) "Sonia" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Placing | Excel Worksheet Functions | |||
placing.. 1st, 2nd, 3rd... | Excel Discussion (Misc queries) | |||
Placing bubbles | Charts and Charting in Excel | |||
placing | Excel Worksheet Functions |