#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default listboxes

Hi,

i have a list box that displays info on a userform. when the userform
is first loaded i can select rows from the list. The problem occurs
when i unload the form and then reload it. Whne i do this the list is
still poppulated with my info but i can no longer select it.

any help greatly received

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 983
Default listboxes

Just to be clear are you unloading the form or hiding the form. What you are
explaining sound more like re-activating a previously hidden form.There is an
initialize event when the form is first loaded and an activate event when the
form is selected. Post the code for both events so we can take a look.

" wrote:

Hi,

i have a list box that displays info on a userform. when the userform
is first loaded i can select rows from the list. The problem occurs
when i unload the form and then reload it. Whne i do this the list is
still poppulated with my info but i can no longer select it.

any help greatly received


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default listboxes

i just use userform.show to load the form
and unload me to remove it

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
listboxes [email protected] Excel Programming 3 February 22nd 05 04:01 PM
listboxes [email protected] Excel Programming 2 February 22nd 05 10:31 AM
Listboxes 2 Denise Excel Programming 2 June 8th 04 06:39 PM
listboxes Mandy[_2_] Excel Programming 3 May 7th 04 04:38 PM
Listboxes Lionel Fridjhon Excel Programming 0 April 5th 04 06:28 PM


All times are GMT +1. The time now is 09:32 AM.

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"