Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default headings in a combo box

Can a combo box display headings or do you have to have
labels on a form above the combo box for the headings?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default headings in a combo box

If you set the items of the combobox in a range, with the heading in the
first row of the range, you can use the RowSource property to link to that
range, and then set the ColumnHeads property to True.

--
Regards

Juan Pablo González

"JT" wrote in message
...
Can a combo box display headings or do you have to have
labels on a form above the combo box for the headings?

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default headings in a combo box

Set the columnheads property to true,
but this will only work if the box if filled using the rowsource or
listfillrange properties (the control is databound). Then it gets its
heading from the row above the range assigned.

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
Can a combo box display headings or do you have to have
labels on a form above the combo box for the headings?

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the headings from A1 A2 etc to show my headings? JaneyMae1 Excel Discussion (Misc queries) 3 October 9th 09 04:17 PM
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
Column headings to numbers and row headings to alphabets? Juliana Excel Discussion (Misc queries) 2 May 9th 08 05:58 PM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 02:05 AM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"