Filter ListBox on a UserForm using a ComboBox

[Jorge24]

Hi, I created a UserForm to enter data into a worksheet. In that UserForm I have a button that opens a ListBox showing all the records stored in the worksheet. I want to filter this ListBox using a ComboBox based on my "Area" column. I populated the ComboBox using unique values from the column. When I try selecting an area, I get an error on the code. Below you will see screenshots of my userforms and my code. If somebody knows how to fix this, please let me know

This is the main userform to enter data. If you click "Open Records" button, it will display ListBox in belows screenshot

Here, it shows all the records stored in my worksheet. I want to use the ComboBox above to filter these records by the area.

When I select an area in gives me this error message

Below is the code that I have to populate the ComboBox and the code to try filtering the ListBox

 

[DanteAmor]

Hi and welcome to MrExcel.

In this case, the loop must start at a number, and you have it with "i".

I don't know which column your data starts in, because you have an offset then - 2. Change the "i" to 3 and try.
For example:

For i = 3 to 14