Question on Formats...

[Alex]

This ought to be quite simple to answer.

Is it possible to format the contents of a combobox?

On sheet1 I have text in cells A1 to A8 e.g A1 = John, A2
= Steve, A3 = Claire etc.

I have a combobox on a chart that displays those names
when I click the down arrow. The default is lower case,
black lettering. Can I make the names appear in bold and
green for example?

I have tried modifying the original names but that makes
no difference. If I right click the combobox and select
<Format Control> I cannot see a way to format my data
entries.

Maybe you can't do it. And I want to avoid writing a
whole load of VBA to do it as keeping the size of this
Excel file down to a minimum is essential this time
around.

Thanks for any insights...

Alex

 

[Guest]

hi
yes is is possible. on the toolbox menu, click design then
right click the combobox. click properties. click on font
then the small gray box. the edit font box will pop up.