Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox.value not equal to listbox.list(listbox.listindex,0)
Odd...
learning vba in excel... I have set up a list box. Have selected a default value by setting listbox.listindex If the user tabs through the selection boxes... (six listboxes on userform)... all is well. If the user just hits the "accept" button... listbox.value is sometimes empty string. i used watch in debug... and found the following for a 12 x 1 array listbox.listindex = 3 listbox.list(3,0) = "aaa" listbox.value = "" listbox.list(listbox.listindex,0) = "aaa" it is not 100 percent consistant which of the six listboxes on the form will screw up. But at least one of the six will every time. I figure it is a timing/update thing... or something very simple that i am doing wrong. any help would be appreciated folks... thank you Andrew Blair Marietta, Ohio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Listbox B if LIstbox A equals | Excel Discussion (Misc queries) | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |