Specific cell
 

Hello,

I am currently building an Excel sheet that need to show a message if a user
changes the value of a specific cell.
For example the message needs to appear if the value of the cell A1 is below
ten, but I only want to show the message when the user changes the value. So
if the user changes cell B1 and the value of A1 is below ten I dont want the
message to appear.

Can anybody help me out?

Best regards,

Chris

Specific cell
 

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$A$1" Then
If Target.Value < 10 Then
MsgBox "A1 changed"
End If
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

"chris" wrote in message
...
Hello,

I am currently building an Excel sheet that need to show a message if a
user
changes the value of a specific cell.
For example the message needs to appear if the value of the cell A1 is
below
ten, but I only want to show the message when the user changes the value.
So
if the user changes cell B1 and the value of A1 is below ten I don't want
the
message to appear.

Can anybody help me out?

Best regards,

Chris

Specific cell
 

Bob,

Thanks for you help it works.

Best regards,

Chris

"Bob Phillips" wrote:

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$A$1" Then
If Target.Value < 10 Then
MsgBox "A1 changed"
End If
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

"chris" wrote in message
...
Hello,

I am currently building an Excel sheet that need to show a message if a
user
changes the value of a specific cell.
For example the message needs to appear if the value of the cell A1 is
below
ten, but I only want to show the message when the user changes the value.
So
if the user changes cell B1 and the value of A1 is below ten I don't want
the
message to appear.

Can anybody help me out?

Best regards,

Chris

Specific cell
 

Here's another option that doesn't require coding.

From the Data Menu, select Validation. The resulting dialog box
provides methods for establishing entered range values as well as a
custom message box when the range has been exceeded.

regards,

mike