listbox value not initialized

  • Thread starter Thread starter John Holland
  • Start date Start date
J

John Holland

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
 
Check you listbox's RowSource property is still set.

What do you mean by "on and off" values?

Patrick Molloy
Microsoft Excel MVP
 
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
 
Back
Top