Data validation warning meesage

[marshen]

Hi all.

I have a cell with a data validation drop down in with the options of YES or NO and I want a error/warning message to pop up when YES is selected but no message when NO is selected.

I have no issues with getting the drop down menu via Data Validation and I know the option for an error/warning message is in there too but I want it to pop up when the YES option is selected but I just can't seem to grasp it

Any advice would be appreciated.

Mark

 

[Norie]

Mark

As far as I know you can't have a error/warning message when using a list, probably because all the values selected in the list are considered valid.

 

[L. Howard]

Maybe try a sheet change event macro, something like this.
In the sheet module, using A1 as the drop down cell.

Howard

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Application.EnableEvents = False
Dim myCheck
    myCheck = MsgBox("Yes was entered.", vbRetryCancel)
    If myCheck = vbRetry Then
       [A1].ClearContents
       [A1].Activate
      Else
       '
    End If
End If
Application.EnableEvents = True
End Sub