Preselecting userform listbox values

**rubthebuddha** · 08-27-2013, 12:12 PM

Good morning/afternoon,

I have a listbox which allows a user to select multiple values. This popluates the workbook's active cell. For times when 10 items of a list of 500 may be selected, I don't want to have an editor of that cell to have to reselect almost all preselected values if they're only looking to remove one of the 10.

How can I have the listbox open up with the activecell's values pre-selected? I've tried several solutions, none of which was I able to adapt. I'm not saying they're not adaptable. The problem lies with my skill.

The code to populate the active cell is below. How can I reverse this to return the values to the listbox when it opens?

Please Login or Register  to view this content.

**Solus Rankin** · 08-27-2013, 12:17 PM

Please Login or Register  to view this content.

**Norie** · 08-27-2013, 12:22 PM

You'll need to split the values in the active cell out.

That can be done with Split which returns an array.

Then you'll need to loop through that array, find each values index (position) in the listbox and select it.

You can use Application.Match to find the index of a value.