Headings for Multi Column Listbox

Posted on 2014-02-20
Medium Priority
Last Modified: 2014-02-22
I have a multicolumn list box in Excel 2010. I can populate its 5 columns but I cannot see how to add headings for each column.

I have set ColumnHeads=TRUE.

Any ideas please?
Question by:NormanMitchell
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 49

Expert Comment

by:Martin Liss
ID: 39874203
ignore me - sorry.
LVL 34

Expert Comment

ID: 39874210
How have you populated the listbox?

You can only have headings if yo've populated it from a range.

If you populated it any other way, eg AddItem, List etc,  no headings I'm afraid.
LVL 49

Accepted Solution

Martin Liss earned 1500 total points
ID: 39874223
You could add labels above the columns or use a ListView control instead.
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

LVL 34

Expert Comment

ID: 39874760
Or you could add a small one row listbox above the existing listbox.

This listbox would contain the headers and would have the same column widths as the existing listbox.

A wee bit easier than trying to line up labels to columns.
LVL 49

Expert Comment

by:Martin Liss
ID: 39875009
Or you could add a small one row listbox above the existing listbox.
Good idea.

Author Closing Comment

ID: 39878939
Shame Microsoft (or the authors of VBA can't provide a simple solution. But yours stirred up my brain to find ways round. Many thanks

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question