Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export listbox items to worksheet
Hi there dear reader...
I have a userform with a listbox. I would like to export the the items of the listbox into a worksheet. Here below my code which doesn't work unfortunately. I don't know why. Dim c As Variant Dim i As Integer c = ThisWorkbook.Worksheets("Sheet1").Range("a1:e5") For i = 0 To ListBox1.ListCount - 1 c(i + 1, 1) = ListBox1.List(i, 1) Next i -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200904/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export listbox items to worksheet
I found the solution.The here below code works
Dim c As Variant Dim i As Integer c = ThisWorkbook.Worksheets("Sheet1").Range("a1:e5") For i = 0 To ListBox1.ListCount - 1 Cells(i + 1, 1) = ListBox1.List(i, 1) Next i Honnore wrote: Hi there dear reader... I have a userform with a listbox. I would like to export the the items of the listbox into a worksheet. Here below my code which doesn't work unfortunately. I don't know why. Dim c As Variant Dim i As Integer c = ThisWorkbook.Worksheets("Sheet1").Range("a1:e5") For i = 0 To ListBox1.ListCount - 1 c(i + 1, 1) = ListBox1.List(i, 1) Next i -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200904/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to disable items in a listbox? | Excel Programming | |||
add items to listbox | Excel Programming | |||
ListBox items paste into worksheet in reverse order | Excel Programming | |||
Adding Items to a ListBox-Unique Items Only | Excel Programming | |||
Items in a Listbox | Excel Programming |