Results 1 to 5 of 5

List display in userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    List display in userform

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1