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
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