Quick question, I believe, How do you display lists within a label on a userform. Right now this is only displaying 1 cell. I need to have the background data in list form as I will be filtering it within the form later.
![]()
Private Sub CommandButton1_Click() Label1.Caption = Worksheets("Sheet1").Range("B1").Value End Sub
Also, if not a label, what would be the best way to display the list, as it will expand in future and something with a scroll would be prefered.
Thanks.
Bookmarks