Calling macro in an IF function ??


Posted by Henriette on January 03, 2001 3:03 AM

I have a cell reference to which the input is a simple yes or no. If the value is true, I would like to run a macro, but is is possible to "call" a macro in an IF sentence - or how can I solve my problem alternatively??



Posted by cpod on January 03, 2001 6:50 AM

You can create a custom function and run it from an if statement. You should be aware though, the only thing you can change with a function is the contents of the cell from which it is called.