View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default How to set the column title in a listbox from Excel

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" wrote in message
...
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?