how do u run a macro when a particular field is changed?

LMF · Mar 19th, 2002, 10:56 AM

how do u run a macro when a particular field is changed?

pls help!

NateO · Mar 19th, 2002, 10:59 AM

If a cell range = field in this case then:

Right click on your sheet, select view code and paste the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:b1000")) Is Nothing Then
application.run("LMF's Macro Name")
end if
end sub

Might want to change your target to something more pertinent to your worksheet.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-19 10:05 ]

LMF · Mar 19th, 2002, 11:13 AM

thank you for the code, but i actually want the macro to run when the value of the cell changes. like if i do If or vlookup.

do u know what i am saying?

[ This Message was edited by: LMF on 2002-03-19 10:31 ]

LMF · Mar 19th, 2002, 11:34 AM

can someone help me pls?

LMF · Mar 19th, 2002, 11:39 AM

pls help me NateO?

NateO · Mar 19th, 2002, 11:43 AM

Please works for me. Try:

Right click on your sheet, select view code and paste the following:

Private Sub Worksheet_Calculate()
application.run("LMF's Macro Name")
end sub

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-19 10:43 ]

LMF · Mar 19th, 2002, 11:45 AM

nothing happen!

NateO · Mar 19th, 2002, 11:47 AM

Do you have your calculation mode set to automatic?

Tools->options->calculation set to automatic & click ok

LMF · Mar 19th, 2002, 11:48 AM

it is working now, but the thing i want it the macro to be run when a particular cell is change...

pls help!

[ This Message was edited by: LMF on 2002-03-19 10:51 ]

NateO · Mar 19th, 2002, 11:51 AM

It's in the correct sheet code module?

It works for me, not sure what the issue is....

Mar 19th, 2002, 11:47 AM	#8
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Do you have your calculation mode set to automatic? Tools->options->calculation set to automatic & click ok __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Mar 19th, 2002, 11:51 AM	#10
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	It's in the correct sheet code module? It works for me, not sure what the issue is.... __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

Mar 19th, 2002, 10:56 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	how do u run a macro when a particular field is changed? pls help!

Mar 19th, 2002, 10:59 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	If a cell range = field in this case then: Right click on your sheet, select view code and paste the following: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1:b1000")) Is Nothing Then application.run("LMF's Macro Name") end if end sub Might want to change your target to something more pertinent to your worksheet. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-03-19 10:05 ]

Mar 19th, 2002, 11:13 AM	#3
LMF Board Regular Join Date: Mar 2002 Posts: 73	thank you for the code, but i actually want the macro to run when the value of the cell changes. like if i do If or vlookup. do u know what i am saying? [ This Message was edited by: LMF on 2002-03-19 10:31 ]

Mar 19th, 2002, 11:34 AM	#4
LMF Board Regular Join Date: Mar 2002 Posts: 73	can someone help me pls?

Mar 19th, 2002, 11:39 AM	#5
LMF Board Regular Join Date: Mar 2002 Posts: 73	pls help me NateO?

Mar 19th, 2002, 11:43 AM	#6
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Please works for me. Try: Right click on your sheet, select view code and paste the following: Private Sub Worksheet_Calculate() application.run("LMF's Macro Name") end sub _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-03-19 10:43 ]

Mar 19th, 2002, 11:45 AM	#7
LMF Board Regular Join Date: Mar 2002 Posts: 73	nothing happen!

Mar 19th, 2002, 11:48 AM	#9
LMF Board Regular Join Date: Mar 2002 Posts: 73	it is working now, but the thing i want it the macro to be run when a particular cell is change... pls help! [ This Message was edited by: LMF on 2002-03-19 10:51 ]