Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Headings for Multi Column Listbox

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?
0
NormanMitchell
Asked:
NormanMitchell
  • 3
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
ignore me - sorry.
0
 
NorieVBA ExpertCommented:
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.
0
 
Martin LissOlder than dirtCommented:
You could add labels above the columns or use a ListView control instead.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
NorieVBA ExpertCommented:
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.
0
 
Martin LissOlder than dirtCommented:
Or you could add a small one row listbox above the existing listbox.
Good idea.
0
 
NormanMitchellAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now