Prev: VBA to count periods in a single cell
Next: updating with now()
From: V Hoang on 22 Dec 2009 09:09
any help here?
From: Ryan H on 22 Dec 2009 09:34
You can do it two ways.

1.) Include a header in your RowSource Range.

2.) You can put Lablels just above your ListBox to label your ListBox columns.

Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan


"V Hoang" wrote:

> any help here?
From: JLGWhiz on 22 Dec 2009 10:10
If ColumnHeads is set to true in the properties window, then the header row
should not be included in the RowSource or ListFill range. VBA will
automatically include the row above the ListFill range as a header if the
ColumnHeads property is set to true.


"Ryan H" <RyanH(a)discussions.microsoft.com> wrote in message
news:C7DAA95E-FF81-4C21-958E-66C8A2E30860(a)microsoft.com...
> You can do it two ways.
>
> 1.) Include a header in your RowSource Range.
>
> 2.) You can put Lablels just above your ListBox to label your ListBox
> columns.
>
> Hope this helps! If so, let me know, click "YES" below.
> --
> Cheers,
> Ryan
>
>
> "V Hoang" wrote:
>
>> any help here?


 | 
Pages: 1
Prev: VBA to count periods in a single cell
Next: updating with now()