Column headings in combo box

[bbcpjc]

hi

I have a combo box. I have a named range as my rowsouce. When I set columnheads = True it does not use the first row of my range as headings, it just leaves them blank and includes my headings in the selections. Have I missed a setting in the combo box.

Thanks for any assistence

bbcpjc

 

[bbcpjc]

Any thoughts on this will be much appreciated

 

[Ivan F Moala]

On 2002-06-11 07:11, bbcpjc wrote:
hi

I have a combo box. I have a named range as my rowsouce. When I set columnheads = True it does not use the first row of my range as headings, it just leaves them blank and includes my headings in the selections. Have I missed a setting in the combo box.

Thanks for any assistence

bbcpjc

No it will use the 1st row of your column source directly ABOVE it ie. if your named range refered to A2:A20 then when you select Columnheaders = True it will use A1 as your column heading.

 

[bbcpjc]

Thanks very much. I now have my headings but it has truncated one of them. This looks like a point size issue as the heading is cut off mid character. I would like the heading to be the same length as the entries below it.

Regards
bbcpjc