Can a Cell Formula run a Macro

cjcobra · Apr 10th, 2002, 11:11 AM

Basically, if a cell in my worksheet equals "1", run Macro X. Is there a formula I can put into the worksheet (i.e. =if(B47=1,application.run "macro",0) which of course doesn't work!, or do I have to use some code in the macro that watches the value of the cell?

Thanks!

AJ · Apr 10th, 2002, 11:15 AM

I don't think so, but the second option you suggest is possible and there are several versions of that on the message board e.g.

http://www.mrexcel.com/board/viewtop...c=4474&forum=2

cjcobra · Apr 11th, 2002, 07:31 AM

Thanks!

That works & got me to the next step!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 11:11 AM	#1
cjcobra Board Regular Join Date: Apr 2002 Posts: 177	Basically, if a cell in my worksheet equals "1", run Macro X. Is there a formula I can put into the worksheet (i.e. =if(B47=1,application.run "macro",0) which of course doesn't work!, or do I have to use some code in the macro that watches the value of the cell? Thanks!

Apr 10th, 2002, 11:15 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	I don't think so, but the second option you suggest is possible and there are several versions of that on the message board e.g. http://www.mrexcel.com/board/viewtop...c=4474&forum=2

Apr 11th, 2002, 07:31 AM	#3
cjcobra Board Regular Join Date: Apr 2002 Posts: 177	Thanks! That works & got me to the next step!