Populate xlValidateList; Please Comment

A

AMDRIT

Hello,

I am seeking a way to specify the validation formula1 with a string. The
values themselves my contain commas.

With Names(NamedRange).RefersToRange

.Validation.Delete
.Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:=xlBetween, Formula1:="10,000, 11,000"
.Validation.IgnoreBlank = True
.Validation.InCellDropdown = True
.Validation.InputTitle = ""
.Validation.ErrorTitle = ""
.Validation.InputMessage = ""
.Validation.ErrorMessage = ""
.Validation.ShowInput = True
.Validation.ShowError = True

End With


Thanks in advance.
 
D

Dave Peterson

I think you'll have to put that list in a range on a worksheet (hidden sheet and
the range nicely named) if the values will include commas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top