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!

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!

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!

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!

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!

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!

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!

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!