Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,227
- Office Version
- 2010
- Platform
- Windows
hi good afternoon, i hope you can help me, i have 10 textboxes in my userform where once submitted the data goes to sheet1 from columns A to S and to last row. i want the data to be seen in my listbox in the userform so i can view it i have tried the code below but its not working i just see the heading in A1 and the line below not anything else.
VBA Code:
Private Sub UserForm_Initialize()
ListBox1.RowSource = Sheets("Sheet1").Range("A1:S3000").Address(external:=True)
End Sub