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 *** |
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 |