Hello, I have this code to populate one listbox but I want to put in it the data filter from sheet1 from carros number. Thanks

Chequeado Cambio
Carros Estado Fecha Gasolina Millas Nombre Aceite Pendiente



Private Sub UserForm_Initialize()
With ListBox1
.ColumnCount = 8
.ColumnWidths = "50;50;50;50;50;100;80;100"
.List = DataSource.Value
End With
TextBox1.Tag = 0
TextBox2.Tag = 1
TextBox3.Tag = 2
TextBox4.Tag = 3
TextBox5.Tag = 4
TextBox6.Tag = 5
TextBox7.Tag = 6
TextBox8.Tag = 7
SheetUpdated = True
End Sub