Data Validation: Escaping Commas in Choice List

I'm building VBA code which installs Data Validation drop-down menues on certain cells across multiple worksheets. Each menu may be different; I build a comma-separated string of choices and install in in the cell with code which looks similar to

Please Login or Register  to view this content.

And this works just fine. HOWEVER, for one cell, the choices (as given to me by the user) are:

• 3 In, 1 Out
• 2 In, 2 Out
• 1 In, 3 Out

But if I spec

Please Login or Register  to view this content.

of course I get six choices, none of them containing commas. I've tried obvious things like

Please Login or Register  to view this content.

without any luck.

I may yet resort to hacks like changing the commas to semicolons, or writing the choices into cells and spec'ing the choices by a range-pointer. But I thought I'd check here first: is there some way to escape the commas so that the Data Validation teams don't split on them?

Thanks for your feedback. Unfortunately, the commas have to be there and they really have to be commas - the choices are set in another standard, and it needs to match character-for-character. Other matters were forcing me towards building a separate worksheet and putting all the choices into ranges. Turns out there's a 255 char limit on the comma-delimited choice-list, so I have to go to ranges anyways. But thanks for the clarifications.

Formula1:="3 In" & Chr(130) & " 1 Out,2 In" & Chr(130) & "2 Out,1 In" & Chr(130) & " 3 Out"
This should cover you