Setting multiple selections in a list box based on a variable
Okay, this seems so simple but I have yet to find any way to make it work.
We have a simple field I'll call GROUP, we load it in our script with distinct values from another field I'll call SALES_GROUP and this field is in two different tables to select different record types but the values are the same across both tables.
Our customer would like to select ORDER_SALES_GROUP on one table in Sheet A (call these Orders), clear it when leaving and then select the PROSPECTS_SALES_GROUP for Sheet B (call these Prospects) and clear it when leaving.
These two fields are not joined, nor does it make sense to do that.
We set up a list box to select GROUP, we save those selections in a variable (vlist) using GetFieldSelections(GROUP)
Example data looks like this in the selection: Current Value of vlist: " 0-In, ACCELVER"
When clicking to Sheet A, we would like to select the ORDER_SALES_GROUP list box using the variable vlist and have set up the triggers using the "select in field" and the value =vlist variable.
This all works fine with a single selected value (e.g., 0-In), but when we have multiple values, nothing gets selected in the ORDER_SALES_GROUP.
Bottom line question: How do you select multiple values in a list box using a variable?
