User form grid - resize / font size

[Guest]

Hi,

How do I resize the default grid in a user form in Excel?

I find controls snap to the grid and label and textboxes do not line up
properly.

Also, I have created about 50 text boxes . I have set the font to size 7 /
arial but when the form is called the fonts of one line always look bigger
(while others look smaller for some reason).

Help

JB

 

[Guest]

Hi,

In the VBE menu choose Tools>Options>General tab> then set the grid size in
the Form Grid Settings frame

 

[Guest]

Thanks!

any idea on why font size looks different even on the same setting?

JB

 

[Rocket2112]

I, too, am seeing the same thing. Even though the text size is set to the same size for my stacked set of labels, one or two will have font sizes which look smaller.