Solved

listBox column headers in VBA

Posted on 2000-02-23
3
3,426 Views
Last Modified: 2008-02-26
I placed a listBox directly on a word document.  I set the columnHead property to true but I can't find a way to put text into the column headings.  How can I do this?
0
Comment
Question by:SteveW
3 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 100 total points
ID: 2552667
Hi SteveW,

it seems that it is a Office 97 restriction that a.o. the column heading cannot be populated in a.o. Word. Information found in following article:

http://support.microsoft.com/support/kb/articles/Q164/3/43.asp

Sorry, maybe Office 2000 can handle this.

Calacuccia
0
 

Author Comment

by:SteveW
ID: 2552902
Office 2000 cannot do this either.
0
 
LVL 9

Expert Comment

by:antrat
ID: 2560742
I just paid 10 points for this <sigh> I'll get you for this Calacuccia, it's a conspiracy I tell you :)

SteveW
Could you insert a Excel sheet and put your list in A2:Awhatever and then set the list range to A2:Awhatever and place your heading in A1.

antrat
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

790 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