Populate and filter Listbox

miami2k

Board Regular
Joined
Nov 1, 2017
Messages
58
Dear All,

I'm struggling to do something that should be quite simple.
I have a large worksheet with header line and a userform to perform operations on it.
One of these tasks is to open another userform with a listbox.
I've been able to populate the listbox, resize the columns etc. but I'm not able to go on.

First of all I've been able to keep the columnheads only using the follwing command to populate the listbox:
Me.ListBox1.RowSource = ListRange.Address
I've read somewhere that if I use other methods, such as filtering the cells and then populating the listbox with visible cells I won't be able to use the columnhead. I'd like to try this method to see if is faster.

Apart from that, my next goal is to filter the rows in the listbox (without deleting or sorting the data in my worksheet) depending on a checkbox or a combobox in the userform.
For example I flag the checkbox, I want the listbox to show only the rows in which column D is empty and/or column G is 0.

Thank you in advance!

miami2k
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top