Automating a macro

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Is there a way to automate a macro based upon what I type
into a cell? (i.e. using an IF/THEN statement...=IF
(A1=1,macro1,false))
 
Worksheet functions can't start a macro, but there are events (worksheet_change
and worksheet_calculate) that might do what you want.
 
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

Using a formula in a macro 2
macros creating 2
Macro to change formula? 5
General Macro/Automation Question 1
How do I execute a macro based on the value of a cell in Excel? 12
Open File 2
Replicating the Format Painter - to add to right-click menu 5
changing cell formulas 1

Back
Top