PDA

View Full Version : text in ColumnHeads



white_flag
09-24-2010, 03:34 AM
In VBA, a regular Combo Box control has a ColumnHeads property to display Column Headers (if you make it true).
Is there a way to put the text in the header? If you make this property true, it puts a blank row (no text) in there at the top.

thank you

Bob Phillips
09-24-2010, 03:54 AM
It can pick up the header from the data if linked to a worksheet range.

white_flag
09-24-2010, 04:38 AM
without link it is not possible?

Bob Phillips
09-24-2010, 05:16 AM
No I don't think it is.