ExcelBanter - Help with Data Validation.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help with Data Validation. (https://www.excelbanter.com/excel-programming/401936-help-data-validation.html)

Ayo

Help with Data Validation.

How do I use this code segment to validate Cell C3 using the name range
"Vendor_List" on worksheets("Vendors")?

With Range("C3").Validation
.Add xlValidateList, xlValidAlertStop, xlBetween, "=$A$1:$A$10"
.InCellDropdown = True
.IgnoreBlank = False
End With

All times are GMT +1. The time now is 01:37 AM.