| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set the column title in a listbox from Excel
any help here?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set the column title in a listbox from Excel
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
| How to rename a column title in excel? | New Users to Excel | |||
| Sumif based on column A and title of another column | Excel Discussion (Misc queries) | |||
| In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
Linear Mode
