Display excel records on listbox based on selected value from the combobox

[NoeMw]

Hey guys, am a newbie to VBA programming... And at work am developing a userform for the excel spreadsheet.

The spreadsheet tracks the operation of the tractor, its attributes include date, opening and closing mileage, fueled on. Now on my userform i have a combobox populated with months and i have managed to change the month selected to number but the problem i want you guys to help me with is this; I dont want to pull all records to my listbox as is the case now I want the user upon selecting his prefered month only the operation records of the tractor for that month should appear on the userform listbox

Thanks in advance.

 

[NoeMw]

By the way here is my code thats pulling records to my listbox, how can this be tweaked as to accomplish my goal stated above, am using Excel 2010

With ListBox1
    .ColumnHeads = True
    .ColumnCount = 4
    
    .RowSource = "Sheet1!A6:D24"
    .MultiSelect = fmMultiSelectSingle
    .BoundColumn = 0
End With