Commas in VBE Data Validation List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am using VBA for data validation lists. One of my lists has
commas within each item, example:
Sales, Marketing and Administration
Parts, Planning
Excel however interprets each comma as 'start the next
item on the next line', so I get in my list:
Sales
Marketing and Administration
Parts
Planning
How do I fix this please? I was thinking it was by using a code (like
CHR(13) is used for carriage return), but can't find anything. So far I have
(all on one line
in the code version):

xlBetween,Formula1:="Sales, Marketing and Administration, Parts, Planning"

Any assistance is appreciated!
 
If you store the list in a named range on a worksheet, you can refer to
that range as the list source. When a cell in the range contains a
comma, the entire cell will be treated as one item in the list.
 
Works great - thanks, Debra!!!!

Debra Dalgleish said:
If you store the list in a named range on a worksheet, you can refer to
that range as the list source. When a cell in the range contains a
comma, the entire cell will be treated as one item in the list.
Click to expand...
 

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

Data Validation Help Needed urgently !!!!!!!!!!! 16
validation list length issue 3
Adding i new item to current data validation list 2
Data Validation List Problem 1
Data Validation Error 0
Data Validation List (conditional) 2
Error 1004 with VBA and validation 2
Trouble with Validation formula1:=Join(... Is '!' a reserved cha 3

Back
Top