Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list property of listbox
please see the code below sub btn_click() 'lis == listbox control in userform set rng = range("a2:a5") lis.list=rng.value 'it's ok set rng = range("a2") lis.list = rng.value 'it' not ok 'how can i ?? 'i don't want to use "additem". end sub *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list property of listbox
If rng.Cells.Count 1 Then
lis.List = rng.Value Else lis.List = Array(rng.Value) End If x taol wrote: please see the code below sub btn_click() 'lis == listbox control in userform set rng = range("a2:a5") lis.list=rng.value 'it's ok set rng = range("a2") lis.list = rng.value 'it' not ok 'how can i ?? 'i don't want to use "additem". end sub *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list property of listbox
please is it possible making with one syntex without if statement? for example lst.List = ~~~~ *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
list property of listbox
isn't .list expecting an array?
x taol wrote: please is it possible making with one syntex without if statement? for example lst.List = ~~~~ *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
ListBox.ColumnHeads Property | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Listbox text property not working correctly | Excel Programming |