does anybody know what the visual basic code is for validation?
does anybody know what the visual basic code is for validation?
Here's an example of validation from one of my VBA coded workbooks...
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=$M$4:$M$15"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks