Validation.

[Nigel Martin]

I need to validate a cell thus:
if cell B14="C" have the validation throw up a message when the user tries to enter data in cell D14. Help !

[Ivan F Moala]

On 2002-05-16 06:32, Nigel Martin wrote:
I need to validate a cell thus:
if cell B14="C" have the validation throw up a message when the user tries to enter data in cell D14. Help !

In D14 for your DataValidation
Goto
Allow > Custom
And enter this formula B14="C"

[kkknie]

I looked at the reply above, but it doesn't allow you to customize the message. Plus, I've never used data validation before. Here's another way.

Enter this code in the code section for the worksheet of interest:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 14 And Target.Column = 4 Then
If LCase(Cells(14, 2).Value) = "c" Then
MsgBox "Your message here"
End If
End If

End Sub

This macro will run whenever the user enters data into cell D14. If you want the user to get the message whenever the cell is selected, you should change the first line of the code to:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

K

[ This Message was edited by: kkknie on 2002-05-16 07:36 ]

[Nigel Martin]

Cheers Guys.

[Ivan F Moala]

On 2002-05-16 07:30, kkknie wrote:
I looked at the reply above, but it doesn't allow you to customize the message. Plus, I've never used data validation before. Here's another way.

Enter this code in the code section for the worksheet of interest:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 14 And Target.Column = 4 Then
If LCase(Cells(14, 2).Value) = "c" Then
MsgBox "Your message here"
End If
End If

End Sub

This macro will run whenever the user enters data into cell D14. If you want the user to get the message whenever the cell is selected, you should change the first line of the code to:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

K

[ This Message was edited by: kkknie on 2002-05-16 07:36 ]

Data validation allows you to enter a msg
and requires no coding so macros disabled
is not a problem.