Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from listbox to cells
I've a 6-column listbox and I set the RowSource property to a named range. I
tried to copy selected row from listbox to worksheet but it does not work ( sometimes does, sometimes does not :( I dont understand why ) What is wrong? For index = 1 To 6 Worksheets("sht1").Cells(7 + index, 9) = ListBox1.list(ListBox1.ListIndex, index - 1) Next index -- icq 25372592 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from listbox to cells
Only problem I would see is if ListIndex = -1 (nothing selected)
-- Regards, Tom Ogilvy "Buddy Lee" wrote in message ... I've a 6-column listbox and I set the RowSource property to a named range. I tried to copy selected row from listbox to worksheet but it does not work ( sometimes does, sometimes does not :( I dont understand why ) What is wrong? For index = 1 To 6 Worksheets("sht1").Cells(7 + index, 9) = ListBox1.list(ListBox1.ListIndex, index - 1) Next index -- icq 25372592 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Binding data to a ListBox without using cells | Excel Programming | |||
Linking Cells to ListBox - How? | Excel Programming | |||
Putting Listbox data in cells | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |