ListBox Control - ColumnHeads property

[Anonymous]

I have a listbox control on my VBA Userform with the ".ColumnCount"
property set to 2.
I wanted to provide a column header row for each of the two columns with
a column description.

By setting the ".ColumnHeads" property to "True", it appears I'm halfway
there. However,
I can't find a property to allow me to place text in these column
headers. What must I do to
place column headers with descriptive text in my list box? I am trying
to avoid using the
ListView OCX control.

Mark Sanchez
SPEC Services, Inc.
Fountain Valley, CA USA

[Anonymous]

I believe that this feature is only available when accessing data from a
database

Disclaimer: I am sure that you could change this feature using the Windows
API.
However, it would not be a ListBox control at that point but rather your own
custom control.

Joe

"Mark Sanchez" wrote in message
news:3B099553.A65FBB64@gte.net...
> I have a listbox control on my VBA Userform with the ".ColumnCount"
> property set to 2.
> I wanted to provide a column header row for each of the two columns with
> a column description.
>
> By setting the ".ColumnHeads" property to "True", it appears I'm halfway
> there. However,
> I can't find a property to allow me to place text in these column
> headers. What must I do to
> place column headers with descriptive text in my list box? I am trying
> to avoid using the
> ListView OCX control.
>
> Mark Sanchez
> SPEC Services, Inc.
> Fountain Valley, CA USA
>

[Anonymous]

Just put the column heading text in the first row. From the Help file:

Remarks
When the system uses the first row of data items as column headings, they
can't be selected.

Mark Sanchez wrote:

> I have a listbox control on my VBA Userform with the ".ColumnCount"
> property set to 2.
> I wanted to provide a column header row for each of the two columns with
> a column description.
>
> By setting the ".ColumnHeads" property to "True", it appears I'm halfway
> there. However,
> I can't find a property to allow me to place text in these column
> headers. What must I do to
> place column headers with descriptive text in my list box? I am trying
> to avoid using the
> ListView OCX control.
>
> Mark Sanchez
> SPEC Services, Inc.
> Fountain Valley, CA USA

--
John Goodfellow
irtf'nm
use "microtouch" to email