Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer data from List Box
I have created a userform with a list box. I have everything working fine
except the OK button. After highlighting the items on the list I want the OK button to find the next open cell in column B and transfer the highlighted items. So what I need help with is the code for transferring items from the listbox to column B on the spreadsheet. Any help is appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer data from List Box
Ronbo
Dim rNextCell as Range 'Find next open cell in column B Set rNextCell = Sheet1.Range("B65536").End(xlUp).Offset(1,0) 'Write value rNextCell.Value = Me.ListBox1.Value If you have a multiselect listbox, see here http://www.dicks-blog.com/archives/2...elect-listbox/ -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ronbo" wrote in message ... I have created a userform with a list box. I have everything working fine except the OK button. After highlighting the items on the list I want the OK button to find the next open cell in column B and transfer the highlighted items. So what I need help with is the code for transferring items from the listbox to column B on the spreadsheet. Any help is appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer data from 3x15 grid to a single list? | Excel Discussion (Misc queries) | |||
excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3 | Excel Worksheet Functions | |||
Schedule - list transfer | Excel Discussion (Misc queries) | |||
Transfer Items to a list with no duplicates | Excel Worksheet Functions | |||
How do i transfer certain lines from one list to another | Excel Worksheet Functions |