PDA

View Full Version : Userform - Column Heads



malik641
06-06-2006, 09:24 PM
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:

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

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

malik641
06-06-2006, 09:31 PM
Huh....apparently Office 97 had this issue with no further update:

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

Norie
06-07-2006, 05:20 AM
This also applies to Excel 2000.

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