Running a macro

Bananaramaman · Mar 22nd, 2002, 07:24 PM

Can anyone tell me how to run a Macro based on the value of another cell. Example if cell A1=23, then run macro named print_all. Any help would be greatly appreciated.

Al Chara · Mar 22nd, 2002, 07:42 PM

How about the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a1").Value = 23 Then call print_all
End Sub

The code has to be put in the module for the worksheet that the cell is in. The code will call print_all everytime the worksheet is changed and cell A1=23.

Bananaramaman · Mar 22nd, 2002, 07:45 PM

Bananaramaman · Mar 22nd, 2002, 07:46 PM

Al, I will try it immediately. Thanks for the quick help.

Mar 22nd, 2002, 07:42 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Range("a1").Value = 23 Then call print_all End Sub The code has to be put in the module for the worksheet that the cell is in. The code will call print_all everytime the worksheet is changed and cell A1=23. __________________ Kind regards, Al Chara

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

Mar 22nd, 2002, 07:24 PM	#1
Bananaramaman New Member Join Date: Mar 2002 Location: Kevin Posts: 4	Can anyone tell me how to run a Macro based on the value of another cell. Example if cell A1=23, then run macro named print_all. Any help would be greatly appreciated.

Mar 22nd, 2002, 07:45 PM	#3
Bananaramaman New Member Join Date: Mar 2002 Location: Kevin Posts: 4

Mar 22nd, 2002, 07:46 PM	#4
Bananaramaman New Member Join Date: Mar 2002 Location: Kevin Posts: 4	Al, I will try it immediately. Thanks for the quick help.