hello everyone

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

the value in cell "FE11" is derived from a formula, which either returns a value of "1" or "0". if the value of cell "FE11"="1" i would like the macro to display a message and alarm sound at the same time alerting the user to take a different course of action.


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 appreciated !!!

thanks in advance

forkliftpete

Hi

You cannot stop the Subroutine to excecute but what you could do is to check which cell the change happened in a specific column and then run the rest of the macro. What you probably also would want to do is cater for the values changing when more than one changes also, like when a user pastes or delete a range of data.

You could do something like this:
Public Sub Worksheet_Change(ByVal Target As Range)
Dim row As Range
   r = Target.row
For Each row In Target.Rows 'If more than one cell was pasted/deleted step through
    c = Target.Column
    If c = 4 Then 'The culumn you would want to check. Macro will exit here if the change was not in column "4"
    '****You code here to check the value of the formula in this specific row
End If
    r = r + 1 'Increment the row value
Next
End Sub

Hope this helps

Regards
Marnus