I have a userform that contains a listbox. I populate the listbox with specific items during the Userform1 initialize.
On the userform, I have command buttons that allow me to move to next and previous records. During the click module, the record gets loaded into the appropriate userform fields.
For the record, I have a field that contains several of the listbox items and they are separated by commas. I need to extract that field and identify which ones are in the listbox so that it can be highlighted as a selected value when the user sees it.
Here's an example:
The listbox has: hat
gloves
mittens
coat
sweater
boots
Field1 in the record has hat,gloves,coat
I want the listbox to display the hat
gloves
mittens
coat
sweater
boots
hat
gloves
and coat should be highlighted as selected.
How can I do this???
Bookmarks