Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 391
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Listbox 2 takes the value of Listbox 1 Illya Teideman Excel Discussion (Misc queries) 3 April 10th 07 03:20 PM
listbox B conditional of input in Listbox A Kim K Excel Discussion (Misc queries) 1 October 31st 06 09:27 PM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM
Is refreshing listbox rowsource in listbox click event possible? Jeremy Gollehon[_2_] Excel Programming 4 September 25th 03 06:45 PM
Sorting ListBox results or transposing ListBox values to other cells for sorting Rob[_8_] Excel Programming 1 July 9th 03 04:35 AM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"