Listbox configuration manually set values

[afontaine]

I have a listbox to select certain sheet names. I am using manually set values to write out the different options. The only problem is that there are multiple values for a given selection.

I know I can do Name:Value but is there a way to do multiple values it would look something like below but I dont think you can use a comma to separate them. I tried putting each value on its own line but then it repeats so MA NY NY NJ NJ PA PA 

MA : MA XML
NY : NY - CP XML, NY - IP XML
NJ : NJ - Directory XML, NJ XML
PA : PA - NRK XML, PA - RK XML

not sure if this is even possible or if there is a workaround

[BenMoss · Accepted solution]

I would consider approaching this in a different way. 

Use the standard setting of just...

MA

NY

NJ

PA

Keeping the default values.

You can then parse the results before joining against a second datasets which has a list of sheets for each state.

Example attached.

Ben

[afontaine]

Thank you for taking the time to build this helped greatly