Copy listbox selection onto my worksheet.

[danbates]

Hi,

Please could someone help me?

I have 3 list boxes and I would like the selection to be added onto my worksheet on the next available blank row.

They are:

ListBoxPALLETISER for column A

ListBoxMARKET for column B

ListBoxWrap for column C

also could I have it that if any of these are not selected then a message box appears stating which one has not been selected?

Any help would be much appreciated.

Thanks

Dan

 

[gallen]

Are the list boxes form controls or Active X?

At what point do you want the selections adding? Does the user click a 'Transfer' button

I assume each listbox is multi-select?

 

[danbates]

Hi gallen,

I have just found a code that works for me and I didn't see your reply until now but thank you anyway for taking the time to respond.

Kind Regards

Dan