ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   listboxes (https://www.excelbanter.com/excel-programming/326366-listboxes.html)

[email protected]

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


Jim Thomlinson[_3_]

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



[email protected]

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



All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com