stop from running everytime a cell is changed
 

i am running the following macro,

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("FE11") = 1 Then
MsgBox "VEHICLE MAY BE DUE FOR A SERVICE !!", vbBEEP +
vbOKOnly
End If

End Sub

i am a newbie to programming and can't figure out how to stop it from
running everytime any cell value is changed in the worksheet other than
"FE11" !

any help would be aprreciated

thanks in advance

bassfisher


--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile: http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

stop from running everytime a cell is changed
 

Add a line at the beginning:

If Intersect(Range("FE11"), Target) Is Nothing Then Exit Sub

--

Vasant



"bassfisher" wrote
in message ...

i am running the following macro,

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("FE11") = 1 Then
MsgBox "VEHICLE MAY BE DUE FOR A SERVICE !!", vbBEEP +
vbOKOnly
End If

End Sub

i am a newbie to programming and can't figure out how to stop it from
running everytime any cell value is changed in the worksheet other than
"FE11" !

any help would be aprreciated

thanks in advance

bassfisher


--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile:
http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

stop from running everytime a cell is changed
 

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address(0,0) = "FE11" then
if Range("FE11") = 1 Then
MsgBox "VEHICLE MAY BE DUE FOR A SERVICE !!", vbBEEP +
vbOKOnly
End If
End if
End Sub

--
Regards,
Tom Ogilvy

"bassfisher" wrote
in message ...

i am running the following macro,

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("FE11") = 1 Then
MsgBox "VEHICLE MAY BE DUE FOR A SERVICE !!", vbBEEP +
vbOKOnly
End If

End Sub

i am a newbie to programming and can't figure out how to stop it from
running everytime any cell value is changed in the worksheet other than
"FE11" !

any help would be aprreciated

thanks in advance

bassfisher


--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile:
http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

stop from running everytime a cell is changed
 

thanks for the advice, but it didn't solve the problem, now it appears
as tho the macro stopped running.


--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile: http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

stop from running everytime a cell is changed
 

Did you disable macros when you opened the workbook?

Did you disable events while you were testing?

bassfisher wrote:

thanks for the advice, but it didn't solve the problem, now it appears
as tho the macro stopped running.

--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile: http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

--

Dave Peterson

stop from running everytime a cell is changed
 

hello dave, no macros are enabled and i am sure the events are on,
think, not sure! so much to learn! so little time!

bassfishe

--
bassfishe
-----------------------------------------------------------------------
bassfisher's Profile: http://www.excelforum.com/member.php...fo&userid=2758
View this thread: http://www.excelforum.com/showthread.php?threadid=47232

stop from running everytime a cell is changed
 

Does this: "no macros are enabled" mean that macros are disabled?

If yes, set the security to medium and reopen your workbook and allow macros to
run.

(I didn't think that was the problem...)

And you're sure the code is under the correct worksheet???

bassfisher wrote:

hello dave, no macros are enabled and i am sure the events are on, i
think, not sure! so much to learn! so little time!

bassfisher

--
bassfisher
------------------------------------------------------------------------
bassfisher's Profile: http://www.excelforum.com/member.php...o&userid=27585
View this thread: http://www.excelforum.com/showthread...hreadid=472323

--

Dave Peterson