Get instant live expert help on I need help with vba sort listbox

I need help with VBA. I have a code with listbox with filtering options. Checkboxes, textboxes and date. My code wont combine those options to filter my data from worksheet into listbox.

I'm having trouble moving multiple columns from one list box to another. ListBox1 is populated with 4 columns from a spread sheet and ListBox 2 is empty. I want users to be able to press the "add button" which will firstly add the item to ListBox 2 and also remove it from ListBox1 so they can no longer choose it. Furthermore, I would like the "remove button" to do the reverse and add the item from ListBox2 back to ListBox 1 whilst deleting it from ListBox2. This is all being done in Excel VBA userform

Im getting an error on this code when trying to filter on VBA userform using listbox: .List = Application.Index(vData, _ Evaluate("Row(1:" & lMatches & ")"), _ Evaluate("Column(1:" & UBound(vData, 2) & ")")) Im getting error : "Application-defined or object-defined error."

I have some VBA code which, when run, stops Excel from closing. It should not do this and I can't see why or how to fix it. Is this the sort of thing you handle ?

I have an excel spreadsheet for a rugby competition with multiple sheets that is running a vba code to sort group tables automatically when match results are entered and then return which teams progress to the next round. The vba code to sort the teams works. However, there is an issue with then using the scrollbar to select an input cell. The cell selected is always the one which would be in the original view and not the view I'm in. Example: If A1 is in the top left corner of the screen and then I scroll to make AB11 the top left cell. I would then select AB11 and the computer would instead select A1. How do I amend the vba code to fix?