I have several multiselect listboxes on a userform. After the user makes their selections, I would like for the data to be transfered to the same row on the spreadsheet (no matter if there is an empty row above it). I can get this to happen with textboxes and single select listboxes, but not with the multiselect. These are skipped completely.

Here is what I have so far.
Please Login or Register  to view this content.
"Inspector1" is the multiselect listbox. Any assistance at all would be greatly appreciated.

I have posted this before, but received no solutions to my problem.

http://www.mrexcel.com/forum/showthr...ox-to-same-row
http://social.msdn.microsoft.com/For...1-2015823fe72d
http://www.ozgrid.com/forum/showthread.php?t=166895

I honestly have no idea what is wrong with it.