Transfering Data from ListBox to Worksheet
I have created a UserForm with a ListBox. If the user clicks on the macro
button €śAdd to List€ť the ListBox is opened with all of the options, and now
you can simply click on the item(s) you want to add to the worksheet sheet in
column B, starting at B8. I have it all set up to the point of transferring
the data (or item(s) selected) to the worksheet. i.e The ListBox of "item
options" comes up perfectly, I can select (highlight) the items I want to add
to the list on the worksheet€¦ but I dont know how to transfer the selected
(highlighted) items to the worksheet in the next open cell, starting with B8
by clicking on the OK command button.
Any help with the code needed for the OK button to transfer the data would
be greatly appreciated.
P.S. Thanks to Dick Kusleika for the previous suggestions, but neither
solved my problem.
|