Calling a macro from an IF statement

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I need to call a macro from an IF statment, when a
condition is met in a different cell. Do I place the IF
statement in a cell AND what code do I use to call the
macro from the IF statement.

Any ideas will help.
Thanks, Frank
 
Frank, you can not call macros (subroutines) in a cell. You can call
functions you create.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
You must log in or register to reply here.

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

Run Macro If Cell have "x" value 0
IF statements in Macros 4
Call Macro 3
Macro to compare two columns and if condition is met write to a co 4
MACRO BASED ON A NUMBER OF CHARACTERS 2
calling a macro within an excel formula 2
VBA set thick borders around non empty cells in range 0
"Or" statement not working 22

Back
Top