Consulting

Results 1 to 3 of 3

Thread: Userform - Column Heads

  1. #1
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location

    Userform - Column Heads

    Hey guys,

    I was wondering how to enter data inside the outlined area of a multicolumn listbox. There are 4 columns and I have the following:

    [VBA]Private Sub UserForm_Initialize()
    Dim myCols(3, 0) As Variant

    myCols(0, 0) = "PDF Name"
    myCols(1, 0) = "Date Created"
    myCols(2, 0) = "Date Last Accessed"
    myCols(3, 0) = "Date Last Modified"

    lstPDF.Column = myCols
    End Sub[/VBA]

    But when I start the userform it enters the Data below the outlined area.....what am I doing wrong?

    I got the method above from the help files, btw.

    Thanks




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  2. #2
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Huh....apparently Office 97 had this issue with no further update:

    http://support.microsoft.com/kb/q164343/




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  3. #3
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    This also applies to Excel 2000.

    As far as I know the only way to have column headings is by populating from a range.

Posting Permissions

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