unable to select a listbox item

[chousm]

I can populate the listbox in an excel userform with filtered data in a spreadsheet and re-order or sort the items in the listbox by clicking on a button. Everything seems to work properly except the listbox appears locked. I couldn't click on any item in the listbox to make a selection and the scrollbar also failed to work. How can I make it to work?

 

[Sektor]

Check "Locked" property - it should be False.

 

[chousm]

Thank you for your quick response. Yes, the "Locked" property is False.

 

[Sektor]

Without actual workbook it's hard to say the reason for being locked. Could you upload your workbook to some cloud storage (OneDrive, DropBox, Google Drive etc.)?

 

[Sektor]

What about "Enabled" property?

 

[chousm]

Thank you, Sektor. The "Enabled" property is true.

Actually I have a multipage control in a userform. Page1 has a listbox with 6 columns and works without any problem. Page2 also has a listbox with 22 columns that gives me the problem. The properties of both listboxes are identical except the columncount and rowsource. The VBA codes for both listboxes are similar. I just could not figure out why it worked on Page1, but failed on Page 2.

 

[Sektor]

So, could you upload your workbook to some cloud storage (OneDrive, DropBox, Google Drive etc.)?

 

[chousm]

Sektor, thank you again. I have solved the problem. In the userform_initialize procedure, I set the "Enabled" property of the listbox in Page1 to true, but forgot to set the listbox in Page2 to true.

 

[Sektor]

You're welcome!