Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Userform Listbox column heads???
1 view
Skip to first unread message
bidur
May 28, 2010, 2:45:03 PM5/28/10
to
TotallyConfused wrote on 09/11/2009 14:23 ET :
> I have a userform with several listboxes. I want to show the column heads in
> the list box. When I set ColumnHeads property for listbox to
"True",
> I only
> get blank columnheads in my list box. Can someone please help me to set
> the column heads in the my list box to show? The only way it works is that I
> add the row when defining the range in my worksheet and setting the
> ColumnHeads to "False". However, this does not work when you have
> check
> boxes because then you get a checkbox next to the name of the column. Can
> someone please? Thank you in advance for any help you can provide. Thank
> you.
>
Try leaving the first row for headings while defining your data range
(recordset).
thanks
Ram Paudel
> I have a userform with several listboxes. I want to show the column heads in
> the list box. When I set ColumnHeads property for listbox to
"True",
> I only
> get blank columnheads in my list box. Can someone please help me to set
> the column heads in the my list box to show? The only way it works is that I
> add the row when defining the range in my worksheet and setting the
> ColumnHeads to "False". However, this does not work when you have
> check
> boxes because then you get a checkbox next to the name of the column. Can
> someone please? Thank you in advance for any help you can provide. Thank
> you.
>
Try leaving the first row for headings while defining your data range
(recordset).
thanks
Ram Paudel
0 new messages