User form grid - resize / font size
 

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

User form grid - resize / font size
 

Hi,

In the VBE menu choose ToolsOptionsGeneral tab then set the grid size in
the Form Grid Settings frame
--

Regards,

Halim


"John B" wrote:

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

User form grid - resize / font size
 

Thanks!

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

JB

"Halim" wrote:

Hi,

In the VBE menu choose ToolsOptionsGeneral tab then set the grid size in
the Form Grid Settings frame
--

Regards,

Halim


"John B" wrote:

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