Tried to find in help but to no avail.
listbox.heads = True
listbox.column = 8
but how to put some text in the headers.
Thanks.....
How to put text in a listbox heads ?
Hot Topic
- Dialog Box, Searching for keywords in an Excel Workbook
- Copying range of cells to another worksheet without copying the drawing objects
- list object
- accessing VBA code from VB.net application
- Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa
- Future of VBA (and VBScript)?
- .NEt and industrial automation
- Novice Programmer needs help
- Excel edit mode
- your view on product roadmaps
Microsoft ISV
- Changing chart series
- User Input on Range Selection
- close excel when finish
- Problems when accessing a text file using ADO
- Lack of mouse scroll wheel support in VBA
- Access 2003 VB code does not execute in form
- Can not connet to BSM server
- Open an excel file
- VS2005: Any more CTP or RC builds to come?
- Error VB6 when I run application in w2k3 Domain Controller
How to put text in a listbox heads ?
Rogermon
HansVonkeman
Which version of Excel are you using If you could provide some additional details I can escalate this to our support team.
thanks,
-brenda (ISV Buddy Team)
MadNes
The support engineer found the following...
I have setup up a office 2000 machine for this case. And do test on ListBox control.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
First, ListBox control has a property ColumnHeads, we can set it as true, then the list box will show header for each column. But this won’t show column header when you use code to insert data.
So there is only work around: Use a label instead of listbox header.
-brenda (ISV Buddy Team)