Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox value not initialized
Peculiar problem with a listbox. After adding a second listbox to a
userform, for some reason on and off the listbox value of the first listbox is not initialized when running the VBA code. Any clues on this ? How can adding a second listbox interfere with code for the first one ? JH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox value not initialized
Check you listbox's RowSource property is still set.
What do you mean by "on and off" values? Patrick Molloy Microsoft Excel MVP -----Original Message----- Peculiar problem with a listbox. After adding a second listbox to a userform, for some reason on and off the listbox value of the first listbox is not initialized when running the VBA code. Any clues on this ? How can adding a second listbox interfere with code for the first one ? JH . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox value not initialized
thanks for your reply Patrick. By on and off, i mean sometimes the
listbox1.value is initialized according to the code i wrote, and sometimes it just is not executing that code. the problem started after adding another listbox to the form. someone has suggested that it had to do with not completely closing the userform when quitting, but i am not sure this is the reason. the rowsource property is still set, as it is executing that line of code well. after that comes the initialization which it just is not executing, any other suggestions that i can look into are most welcome, thanks, JH "Patrick Molloy" wrote in message ... Check you listbox's RowSource property is still set. What do you mean by "on and off" values? Patrick Molloy Microsoft Excel MVP -----Original Message----- Peculiar problem with a listbox. After adding a second listbox to a userform, for some reason on and off the listbox value of the first listbox is not initialized when running the VBA code. Any clues on this ? How can adding a second listbox interfere with code for the first one ? JH . |
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.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
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 |