CHANGE FONT SIZE IN COMBO AND lIST BOX - excel forms

[Nicos67]

Hi All,

How do I change the size of font within Combo and List boxes within Excel Forms

Many thanks in advance

Nico

 

[xlbo]

AFAIK, you don'e - use a CONTROLS TOOLBOX control instead which has font properties

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Nicos67]

Thanks Goff very kind have opened control tool boc have 5 tabs

Size, Protection, Properties, Web and Control

Cant find font size any where within these 5
is there an alternative?
as control only shows
input range
Cell link
Drop down lines
3d shading

I'm I missing something


Many thanks Geoff

Nico

 

[xlbo]

That is a combobox from the FORMS toolbar - you need to use the one from the CONTROLS TOOLBOX toolbar

View>Toolbars>Control Toolbox

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Nicos67]

Many Thanks Geoff