Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfering of data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Transfering data from worksheet to another | Excel Discussion (Misc queries) | |||
Transfering a row of data to a template word or worksheet | Excel Discussion (Misc queries) | |||
Transfering data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Transfering data from one worksheet to another Worksheet | Excel Programming |