User form grid - resize / font size

[John B]

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

 

[Halim]

Hi,

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

 

[John B]

Thanks!

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

JB