Search Result are loading slow in Listbox in Excel.

[ahsan.masood1980]

Hi There,
I am working on data to search through listbox. It is working fine but when i search any text it make the data search very slow and takes time. Could you please help me to resolve this problem.

Please Login or Register  to view this content.

also i am unable to extend second text to view it properly.
How can i extend the text to view in listbox ?

Thanks

[mehmetcik]

1. Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


2. Right Click on the Listbox in viual basic and select properties

Select Column Widths and enter your required widths eg "8, 32, 64, 128"

3. I never use the Listbox RowSource function. I find it restrictive.

[mehmetcik]

This will fill your listbox

Please Login or Register  to view this content.

Another way is:

Please Login or Register  to view this content.