Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I add a value containing a comma to a dropdown's csv list
If there's no escape character, I'll use another character instead of comma, probably semicolon. But it's a shame to give the user a different string just because the Office designers didn't think through this very basic design. Similarly, I could use chr(130), but then it's misleading, e.g...- rastr
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How can I add a value containing a comma to a dropdown's csv list
In a previous thread, to make a dropdown list in Excel, someone said to use: Public Sub CreateList() With ActiveCell .Validation.Delete .Validation.Add xlValidateList, , , "Value1,Value2,Value3,Value4" End With End Sub I want one of my values to contain a comma. Is there a way to...- rastr
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
