Populate cells with listbox selection

[ozi]

Hi Guys

Hoping you can help. I have a listbox, with multi select option enabled. What I would like to be able to do is to populate a column on another sheet with the values selected in the listbox. Sounds simple, but I can't seem to get it right.

Any help would be much appreciated.

Thanks
Oz

[boylejob]

Oz,

Is your list box directly on your spreadsheet or part of a UserForm?

[ozi]

Hi Jeff

My listbox is part of a user form

Cheers

[royUK]

see if this helps

[ozi]

Hi, thanks for the link, unfortunately my firewall at work will not permit downloads of zip files, would you mind posting that again as an excel file?

Many thanks
Oz

[boylejob]

Oz,

This is how I have always done it.

Please Login or Register  to view this content.

Of course you would put the name of the sheet you are wanting the data transfered to where it says Sheet Name. You would also put in the name of your UserForm and your ListBox.

I am not sure if this is what you are looking for, but maybe it will help.