execute a macro from within an if(,,) function?

  • Thread starter Thread starter David Henderson
  • Start date Start date
D

David Henderson

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop Command Question 4
Macro creation via VBA 26
Automatically Excuting a Macro in a different workbook ? 10
Choose a macro from within a macro 2
Screen Updating 2
Problem in updating all worksheets of a workbook using a macro that calls another macro 3
VARIABLES AGAIN 3
Check cell status on Calculate event: resource issues? 2

Back
Top