Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox control in VBA
in a multi-column listbox I want to set column headers. There is a property ColumnHeads which I set to true, but everything I have tried ended up with the intended header text being displayed as the first data row, and the actual headers remained blank
Anyone who knows how to do this, or even better, has actually done something similar?? I use Excel version 10 (Excel 2002) for development, but the application must work in version 8 (Excel 97) or later version From the Microsoft Excel Visual Basic Referenc "ColumnHeads Propert Displays a single row of column headings for list boxes, combo boxes, and objects that accept column headings Synta object.ColumnHeads [= Boolean The ColumnHeads property syntax has these parts Part Description object Required. A valid object. Boolean Optional. Specifies whether the column headings are displayed. Setting The settings for Boolean are Value Description True Display column headings. False Do not display column headings (default). Headings in combo boxes appear only when the list drops down Remark When the system uses the first row of data items as column headings, they can't be selected" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox control in VBA
The column heads are the row above your rowsource or listfill range
property. So if your data is in A1:C20 for example, with column headings in Row 1, you would set your rowsource or listfill range property to A2:C20 and set ColumnHeads to true. -- Regards, Tom Ogilvy "Ard" (without_this_trailer ) wrote in message ... in a multi-column listbox I want to set column headers. There is a property ColumnHeads which I set to true, but everything I have tried ended up with the intended header text being displayed as the first data row, and the actual headers remained blank. Anyone who knows how to do this, or even better, has actually done something similar??? I use Excel version 10 (Excel 2002) for development, but the application must work in version 8 (Excel 97) or later versions From the Microsoft Excel Visual Basic Reference "ColumnHeads Property Displays a single row of column headings for list boxes, combo boxes, and objects that accept column headings. Syntax object.ColumnHeads [= Boolean] The ColumnHeads property syntax has these parts: Part Description object Required. A valid object. Boolean Optional. Specifies whether the column headings are displayed. Settings The settings for Boolean a Value Description True Display column headings. False Do not display column headings (default). Headings in combo boxes appear only when the list drops down. Remarks When the system uses the first row of data items as column headings, they can't be selected" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shrinking Listbox from Control Toolbox | Excel Discussion (Misc queries) | |||
Wrap text in a control listbox | Excel Discussion (Misc queries) | |||
Control ToolBox ListBox Irratic | Excel Programming | |||
Control Toolbox ListBox Properties Blank | Excel Programming | |||
Enabling checkboxes in a listbox control | Excel Programming |