ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel IF/ELS to all Macro (https://www.excelbanter.com/excel-programming/425332-excel-if-els-all-macro.html)

freddy

Excel IF/ELS to all Macro
 
I want to use a Macro to conditionally call 1 of 2 macros

I have a worksheet called "DO NOT DELETE" that has a cell (E54) with a YES
or NO in it.

If it is YES, I want to call a macro called tagright and if it is NO, I want
to call a macro called tagrightno

Any help would be greatly appreciated.

Sam Wilson

Excel IF/ELS to all Macro
 
If ucase(worksheets("DO NOT DELETE").range("e54").value) = "YES" then
Call tagright
else
Call tagrightno
end if

"Freddy" wrote:

I want to use a Macro to conditionally call 1 of 2 macros

I have a worksheet called "DO NOT DELETE" that has a cell (E54) with a YES
or NO in it.

If it is YES, I want to call a macro called tagright and if it is NO, I want
to call a macro called tagrightno

Any help would be greatly appreciated.



All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com