Re: Automating a macro

Giganews Newsgroups
Subject: Re: Automating a macro
Posted by:  Dave Peterson (ec357…
Date: Tue, 07 Oct 2003

Worksheet functions can't start a macro, but there are events (worksheet_change
and worksheet_calculate) that might do what you want.

Tom wrote:
> 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))


Dave Peterson



In response to

Automating a macro posted by Tom on Tue, 7 Oct 2003