Sub DataValidation()
Columns("A:A").Select ' Validation Applied
With
Selection.Validation
'.Delete
.Add Type:=xlValidateList,
AlertStyle:=xlValidAlertStop, Operator:=xlBetween,
Formula1:="=$B$1:$B$4" ' Validation Range
.IgnoreBlank =
True ' IF blank needs to be ignored. True or False
.InCellDropdown
= True
.InputTitle =
""
.ErrorTitle =
"Application Error" ' Error Title
.InputMessage
= "Select Name" ' ALT text can be used as description about drop down
.ErrorMessage
= "Select the Correct Field" ' Error Message
.ShowInput =
True
.ShowError =
True
End With
Range("A1").Select
End Sub
Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers!
ReplyDeleteEmail List Cleaning
Thank You !
Delete