PDA

View Full Version : control box: how to change the size of the font



csavini
01-25-2008, 10:32 AM
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
7702

Andy Pope
01-25-2008, 12:43 PM
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
01-25-2008, 01:10 PM
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?