MultiSelect Listbox selections to cells

[Borg]

Hello,

I have a MultiSelect Listbox with two columns of data and I want to enter the listbox row data into different cells of a sheet. For example, the selected listbox first column data to be entered to Sheet1, activecell and rows below (for other multiple selections), and the selected listbox second column data to be entered to Sheet1, activecell(0, 2) and rows below (for multiple selections).

Can someone help me with this? I have searched the internet and found code that work partially for what I want to do; but, not to enter data starting at an activecell and a different cell further apart from the activecell.

[rylo]

Hi

See if this gives you some ideas.

Please Login or Register  to view this content.

rylo

[Borg]

Thanks! It worked perfectly to what I was trying to do.

[Ron2335]

Hi Same problem, but how can you make the Next listbox selection populate the next row of cells, so the your building a list on Sheet1?