Hi,
I would like to fill my listbox with the date of the filtered sheet (column A)
here's what I'm using currently
Private Sub UserForm_Initialize()
TextBox1.Text = Sheets("Call Stats").Range("G3").Value
Dim i As Long, j As Long
lastrow = 1
For i = 1 To 3
j = Sheets("Notes").Cells(Rows.Count, i).End(xlUp).Offset(1, 0).Row
If lastrow < j Then lastrow = j
Next i
Sheets("Notes").Activate
ListBox1.RowSource = Range("A2" & lastrow & ":" & "C" & lastrow).Address
vntList = Sheets("Notes").Range("A2" & lastrow & ":" & "C" & lastrow)
ListBox1.ColumnWidths = "60;70;200"
TextBox2.Value = lastrow - 2
Sheets("Call Stats").Activate
End Sub
the problem I am having is that
1. the header is showing the first data row not my headers
2. when the filters change, it doesnt add just the filtered
here's a sample file: Book1.xlsmitems
Bookmarks