Hi. Try:
![]()
Private Sub UserForm_Initialize() With ThisWorkbook.Sheets("Sheet4") ' Fill ListBox Me.listBox1.List = .Range("A2:L" & .Cells(.Rows.Count, 1).End(xlUp).Row).Value End With End Sub
Hi. Try:
![]()
Private Sub UserForm_Initialize() With ThisWorkbook.Sheets("Sheet4") ' Fill ListBox Me.listBox1.List = .Range("A2:L" & .Cells(.Rows.Count, 1).End(xlUp).Row).Value End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks