Reminder Message

[adamsm]

Hi,

How could I create a message "Please Try Again" If the user types any text in Cell M9 other than the text "Other"?

Any help on this would be kindly appreciated.

Thanks in advance.

 

[shg]

Have a look at http://www.contextures.com/xldataval01.html

 

[dave3009]

Use data validation, Data>>Data Validation>>List, put Other in the values box and set your error message

 

[adamsm]

Im sorry but Im not wanting an error message. But im wanting a custom message to give an instruction to the user. "Please Try Again" is an example. My original message is Please enter Customer ID". Having this situation should I still do what you have mentioned?

 

[dave3009]

Hi,

How could I create a message "Please Try Again" If the user types any text in Cell M9 other than the text "Other"?

Any help on this would be kindly appreciated.

Thanks in advance.

Your OP has been answered in a similar vain by two individuals. If you need this to do something else then explain it in full so you can get a complete response.

 

[adamsm]

What I want is a worksheet even code that would popup a custom message saying "Please enter Customer ID" if the user types any text in cell M9 other than the text "Other".

I hope I've made my question clear.

 

[mikerickson]

If you use data Validation (on cell A1 for example), with style set to Information and the formula =(A1="Other"_, the message will be delivered when the user enters anything but "Other".

Event code is inferior to the built in DataValidation for this task.

 

[shg]

It is clear, and you might take a few minutes to read the information at the link.

 

[adamsm]

This is what I wanted.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("M9") <> "Other" Then
    MsgBox "Please enter Customer ID"

End If
End Sub