Results 1 to 5 of 5

List box with multiple columns and headings

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2008
    Location
    Illinois
    MS-Off Ver
    Microsoft Office Excel 2003
    Posts
    85

    List box with multiple columns and headings

    I am trying to figure this out. I have a userform with one listbox with 7 columns that displays a range. It is working except i cannot get the column headings to work. Can someone show me what im missing? Thank you.
    Private Sub UserForm_Initialize()
        Dim rng As Range
        With Sheets("Time")
            Set rng = .Range(.Cells(2, 7), .Cells(.Rows.Count, 1).End(xlUp))
            Me.ListBox1.List = rng.Value
        End With
    End Sub
    Attached Files Attached Files
    Last edited by Khaos176; 01-19-2009 at 04:32 PM.

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