control box: how to change the size of the font

[csavini]

Hi;

I am having a problem with a control box in excel. I placed a control box in excel via the toolbar and now the font inside is exceptionally small. I cannot read the text on it. How do I increase the text? Do I need to install a control box through VBA? Please help me. I am stuck on this and need to complete soon.

I attached a demo file for you to see.

Thanks,
Chris
Attachment 7702

[Andy Pope]

Hi,

The reason the text is very small is the zoom level on the sheet is 55%.
If you set it to 100% the text is normal are readable.

Forms controls do not have a property you can set to fix font size.

You could use a dropdown list from the Control Toolbox, which does have a font size property.

[csavini]

I know all of that....i tried the control toolbox and i still cant get it all to link and to expand in size.

As for the Zoom level. it is to be used on a small number becuase there is more information that needs to be seen. I had to delete it due to its sensitivity. This is a project for work and I cannot just have our information all over the net. Do you have any other suggestions?