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

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

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