List Box multi select

Hello,

An example with

1) create a UserForm1 with ListBox1 and copy the following code

Please Login or Register  to view this content.

2) Create a sheet "test" with more data in A1: C36

3) copy the following code in a standard module

Please Login or Register  to view this content.

4) run the macro UFshow

Best regards.

PMO
Patrick Morange

I looked at your sheet..... I probably didn't word the question properly or explain well enough...

Lets say I have a userform with ListBox1 (multiselect) and it loads with a bunch of cities... so the user chooses Denver and Detroit... then presses a command button and it saves that ListBox1 info to that record in my data.

Now when I load that record using another command button i want the form to highlight his choices automatically (Denver and Detroit) but still show all the ListBox1 entries...

I tried ListBox1.value = cells(n,5).value but there was an error

I don't know if this is possible...thanks for any help

JJ

Hello,

Here is a new version.
I hardly understand English and I hope I have understood your request.
Make a test with the new attachment.

1) create a sheet named "test" and, from A1, put the city names.
2) create a sheet named "save" and leave it blank.
3) create a UserForm1 with CommandButton1 and CommandButton2.
In the code window for the UserForm, copy the following code

Please Login or Register  to view this content.

4) In a standard module, copy the following code

Please Login or Register  to view this content.

5) Run the macro UFshow.

Best regards.

PMO
Patrick Morange

thanks Patrick... I modified it to what I needed but it works great...