Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
How about
If Range("A1").Value = "Yes" Then Call Macro2 or am I missing something obvious? "Darin Kramer" wrote in message ... Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
Hi
should this macro run automatically? -- Regards Frank Kabel Frankfurt, Germany "Darin Kramer" schrieb im Newsbeitrag ... Howdie! I need to run a macro that, depending on the result in a cell, runs another Macro (second macro is just a hide of a column) So for example, when the user runs Macro 1 it needs to check the value in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 = No, then dont run any Macros and the first macro can be stopped. Any ideas? Thanks and Regards Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
No, its not necessary - User can initiate macro. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
Hi
then use Jack's suggestion at the beginning of your macro -- Regards Frank Kabel Frankfurt, Germany "Darin Kramer" schrieb im Newsbeitrag ... No, its not necessary - User can initiate macro. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
AWESOME thanks!!! Just did not know VB that well - Call Macro is the command I wanted!! Thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
Can I just duplicate that command for the result of a different cell running another macro....? doesnt seem to work, unless I need to add an and...or the like.... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a Macro depending on a result of a cell
Hi
maybe explain your COMPLETE requirements :-) -- Regards Frank Kabel Frankfurt, Germany "Darin Kramer" schrieb im Newsbeitrag ... Can I just duplicate that command for the result of a different cell running another macro....? doesnt seem to work, unless I need to add an and...or the like.... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running macro depending on cell value | Excel Worksheet Functions | |||
How to insert line of text on other worksheet depending upon result in a cell? | Excel Discussion (Misc queries) | |||
How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) | |||
Macro to coppy cells to certain rows depending on value in cell | Excel Discussion (Misc queries) |