Multiple Selection Listbox in Userform

[Fadil]

Hi,

I need help to create Listbox from data tab, where I can do multiple selection on a listbox and then the selected items to create a string which I could use on searching data.

I have attached a sample. For example, on Sheet 1 tab I have the data. I want to be able to create userform where I can select just the options I want and output those into the Output tab.

Please advise. Your help is always greatfully appreciated

Regards,
Fadil

 

[Fadil]

One thing I forgot to add to my original text is that once the userform is created, I would have a need to search for particular text and the list box to get shortlisted by the search name so then from the short list I would be able to do multiple selection

Regards,
Fadil

 

[Deepak]

Always try to explain with requirement in very first post as this will help in drawing the image else the one who will respond earlier will get stressed. "I did opposite of the req."

 

[Fadil]

Always try to explain with requirement in very first post as this will help in drawing the image else the one who will respond earlier will get stressed. "I did opposite of the req."

I didn't understand what you meant with "I did opposite of the req"

Regards,
Fadil

 

[Fadil]

Hi all,

I have came to somewhere, but I can't complete the task but step by step getting there. Please look at the attached and see if you can help me finalize this task / project.

I have managed to create the list, copied a code that transfers the data, but I need now to search for data on the list. For example I want to select all Jan data from a long list, where it will filter the list and I can only select what I need containing the search criteria and then transfer data with the transfer button

Begging for your help please,

Regards,
Fadil