Validation from a list

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there any way to include items in a list to be
validated that include commas (delimeter)?
 
You can include commas if the range is drawn from
worksheet cells. For example, suppose C2=Phil, Don
C3=Sally,Mary C4=Jim, Jane
The following sub creates a Data...Validation...List in
the active cell with three items, each including an
embedded comma:

Sub ValidateMe()
ActiveCell.Validation.Add Type:=xlValidateList,
Formula1:="=$C$2:$C$4"
End Sub
 
You must log in or register to reply here.

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

Similar Threads

I need some help with Arrays 2
limit on the delimited list for Data Validation. 2
get Data Validation to stop, list supplied, duplicate data entries 1
Data Validation List (conditional) 2
How to Update Selections for (Numerous) Validation Lists 1
split the contents of a cell 6
validation list length issue 3
Referencing data validation list in IF Statement 2

Back
Top