ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   execute a macro from within an if(,,) function? (https://www.excelbanter.com/excel-programming/351309-execute-macro-within-if-function.html)

David Henderson

execute a macro from within an if(,,) function?
 
Hi all
Please could somebody tell me if it is possible to call a macro from an if()
function

eg if (condition true, macro1,macro2)
I am thinking not, but ....?
Any help would be much appreciated
Thanks in advance
David



Bob Phillips[_6_]

execute a macro from within an if(,,) function?
 
You can call a function if that function just returns a result, but not
anything that looks to change some attribute of the worksheet, such as font,
colour. These type of functions are called User Defined Functions (UDF).

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"David Henderson" wrote in message
...
Hi all
Please could somebody tell me if it is possible to call a macro from an

if()
function

eg if (condition true, macro1,macro2)
I am thinking not, but ....?
Any help would be much appreciated
Thanks in advance
David






All times are GMT +1. The time now is 01:44 PM.

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