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

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


.

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


.