I have validation data " Yes and NO" set up on a sheet. How can I check if selection is "YES" or "NO"? e.g return TRUE if YES, False if NO
Any help will be appreciated.
Thank you
Code;
Code
Private Sub NewDataSheet(SheetName As String)
Dim Ws As Worksheet
.Range("D1").Value = "YES"
.Range("E1").Value = "NO"
Set Ws = Worksheets(SheetName)
With Ws.Range("B1").Validation
.Add xlValidateList, xlValidAlertStop, xlBetween, "=$D$1:$E$1"
.InCellDropdown = True
.InputTitle = True
.ShowInput = True
End With
End Sub
Display More