Why is my List Box deselecting items by itself?

Question

I've created a macro which references an Excel workbook for Name:Value pairs.  For some reason, certain values are automatically deselected after clicking away from the macro.  It seems to be specific to those Name:Value pairs where the Value contains special characters e.g. periods, commas, single quotes, etc.   I those 3 as examples, though I suspect the problem is specific to Values which have commas.   I tried converting the XLSX file to a YXDB to no effect.

How might I go about resolving this?

gregalanraslan · Accepted Answer

Issue identified and solved.

Issue exists when the List Box has Generate Custom List selected and the Seperator field contains a value which also exists in the Value of a Name:Value pair.

Solution:  Change the seperator to a value which does not exist in any of the Name:Value pairs (e.g., '|||' instead of ',') and use the Replace function downstream to change the values back to commas.