Excel UserForm Grid Size: Spacing, Settings, and Layout

In Excel VBA, a UserForm’s design grid is adjustable in the Visual Basic Editor; it does not have one fixed size. On Windows, open the VBA editor and go to Tools > Options > General, then change the Width and Height under Grid Settings; those values set the spacing between design-grid points, not the size of the form itself.

What Excel UserForm grid size means

The phrase “UserForm grid size” can refer to several different things. Most often, it means the horizontal and vertical spacing used to position controls while you build a form in the VBA editor. The grid is a design aid: it helps you place buttons, text boxes, labels, and other controls in a consistent pattern.

It does not set the UserForm’s overall width or height, define a number of rows and columns, or create a data-entry table. A UserForm is a window that contains controls, rather than a worksheet made of cells. The grid’s spacing and visibility are separate from the dimensions of the form and the dimensions of each control.

In the VBA editor, the grid can be shown as dots or other faint markers in the UserForm designer. If Snap to Grid is enabled, moving or resizing controls makes their edges or positions align with grid increments. The grid is not shown to someone using the finished form at runtime.

Where to change the grid settings

In Excel for Microsoft 365 on Windows, use these steps:

Press Alt+F11 to open the Visual Basic Editor.
Choose Tools > Options from the editor’s menu.
Open the General tab and find Grid Settings.
Set the Width and Height values to the spacing you want, then select or clear Show Grid and Snap to Grid as needed.
Return to the UserForm designer and move or resize a control to see how the new settings feel.

These are settings in the Visual Basic Editor, not in Excel’s main Options dialog. The grid settings are generally editor-level design preferences, so they can affect how you work on different UserForms rather than changing only one form’s saved appearance. The exact labels or presentation can vary slightly between VBA editor versions.

A spacing of 6 points horizontally and vertically is a common starting value, but it is not a required setting. Smaller values allow finer placement; larger values make it easier to keep many controls aligned. If you change the numbers and the form does not visibly rearrange, that is expected: changing the grid does not automatically move existing controls.

How the grid works with points and control dimensions

The Width and Height settings describe the interval between grid positions. They are independent, so a grid can use different horizontal and vertical spacing, although equal values are usually easier to work with. For example, a 6-by-6-point grid has six points between neighboring positions in each direction.

Office form and control dimensions are expressed in points. There are 72 points in an inch, so 6 points equal one-twelfth of an inch. This is a measurement relationship, not a promise that the grid will look exactly one-twelfth of an inch apart on every monitor: display scaling, resolution, and the editor’s rendering affect how it appears on screen.

Controls also have their own position and size. In the Properties window, a control’s Left and Top values describe its position relative to its container, while Width and Height describe its dimensions. A control can be wider or taller than one grid interval, and its size does not have to be a multiple of the grid spacing if you adjust its properties directly.

Choosing a useful spacing

Choose a grid that makes alignment easy without forcing every control into an awkward position. A fine grid is useful for compact layouts, narrow gaps, or small controls. A coarser grid is convenient for forms with larger buttons, labels, and text boxes arranged in repeated rows. The best setting depends on the layout, not on a universal Excel standard.

Use a smaller interval when you need precise placement or have controls that must fit into a tight area.
Use a larger interval when the form uses repeated rows and columns and you want quick, consistent alignment.
Keep the two intervals equal for a regular-looking layout unless the design clearly needs different horizontal and vertical spacing.
Temporarily turn off snapping if a control needs to sit between grid positions, then turn it back on for the rest of the layout.

For example, imagine a data-entry form with a label and text box on each of six rows. A moderate grid makes it straightforward to keep the labels aligned and maintain equal vertical gaps. If the text boxes are all slightly too wide after snapping, you can select them and adjust their Width values in the Properties window rather than changing the grid solely to control their size.

Grid spacing versus the size of the UserForm

To change the actual form dimensions, select a blank area of the UserForm and edit its Width and Height properties in the Properties window. You can also drag the form’s borders in the designer. These dimensions determine the form’s design surface; the grid merely provides positions on that surface.

This distinction matters when a form is too small to show all its controls. Increasing grid spacing will not make the form larger, and reducing the grid will not create additional room. Increase the UserForm’s dimensions, reorganize the controls, or consider whether scrolling is appropriate. A form can also have a different apparent size at runtime because the Windows display environment affects how a window is rendered.

Likewise, if a button looks too small, change the button’s Width and Height rather than expecting a grid adjustment to enlarge it. The grid helps with placement; it is not a control-sizing rule.

Using the Properties window for precise layout

Snapping is convenient for approximate alignment, but the Properties window gives direct control over numeric positions and sizes. Select a control and press F4 to show the Properties window if it is hidden. For a clean layout, set matching Left values for controls that should share a vertical edge, matching Top values for controls on the same line, and consistent Width or Height values for repeated controls.

When several controls are selected, the editor’s alignment and sizing commands can also help make their arrangement consistent. Menu availability can depend on the selection and editor version. For a small form, grid snapping may be enough; for a dense form, combining snapping with numeric properties is usually more reliable than trying to judge every distance visually.

Use the form’s own coordinate space as your reference. A control inside a Frame is positioned relative to that Frame, not directly to the outer UserForm. This is a frequent reason why a Left or Top value seems surprising: it is measured from the control’s immediate container.

Common grid problems and fixes

The dots are missing: Return to Tools > Options > General in the VBA editor and check Show Grid. The grid can be hidden while snapping remains a separate setting.
A control jumps while being moved: Snap to Grid is likely enabled. Keep it on for consistent layouts, or turn it off temporarily for finer placement.
Changing the spacing did not move anything: Grid settings do not reposition existing controls automatically. Move them again, or set their properties manually.
Controls still look uneven: They may have different dimensions, be positioned inside different containers, or have values that do not align. Compare their Left, Top, Width, and Height properties.
The form looks different on another display: A grid setting controls design spacing, not the physical pixel size of the finished interface. Consider screen scaling and test the form at a realistic size.

Another common misunderstanding is to treat the designer grid as a guarantee that a form will scale responsively. It is not a responsive layout system. The grid does not automatically rearrange controls when a user resizes a window or uses a different screen. Design the form for the intended use, test it at runtime, and avoid placing important controls so close to the edges that small display differences make them uncomfortable to use.

Is a UserForm grid a spreadsheet-style table?

No. The grid in the UserForm designer is only a placement guide. If the goal is to display tabular information, a worksheet range may be the simplest option. Within a UserForm, a ListBox can show multiple rows and columns of data, while labels and text boxes can create a fixed form-like arrangement. These are different design choices from changing the designer grid.

A ListBox’s row and column behavior is configured through its own properties and data source; the UserForm’s Width and Height grid settings do not determine how many records it displays. Similarly, placing controls in a row does not give them spreadsheet cells or worksheet-style editing behavior. Choose controls based on what the user needs to view or enter, and use the design grid only to arrange those controls.

Windows, Mac, and Excel for the web

The menu path above applies to the VBA editor in Excel for Microsoft 365 on Windows. On Mac, the Visual Basic Editor’s menus and options can differ by Excel and editor version, so look for the grid or alignment options in that editor rather than assuming the Windows path is identical. UserForm and control behavior can also differ between platforms, so verify the finished form on the computers where it will be used.

Excel for the web does not run VBA macros or display VBA UserForms. A workbook that depends on a UserForm therefore needs to be opened in a desktop version of Excel that supports the required VBA functionality. The design grid setting does not change that compatibility limitation.

Frequently Asked Questions

What is the default Excel UserForm grid size?
A 6-by-6-point spacing is a common default or starting value in the VBA editor, but the setting can vary if it has been changed. Check the Width and Height fields under Tools > Options > General rather than relying on a presumed default.

Can I change the grid size for just one UserForm?
The grid options are Visual Basic Editor design settings, not a Width and Height property stored as part of an individual form’s layout. Changing them does not resize the form or automatically reposition its controls.

How do I turn off snapping in a UserForm?
In the VBA editor, open Tools > Options > General and clear Snap to Grid. You can leave Show Grid enabled if you still want the visual guide while placing controls more freely.

Does UserForm grid size affect how the form looks when it runs?
No. The grid is for designing the form. Runtime appearance depends on the UserForm and control dimensions, their positions, and the environment in which Excel displays the window.

Can I make a UserForm behave like an Excel table?
Not by changing the grid. The grid does not create cells or table behavior. For rows and columns of displayed data, consider a ListBox or a worksheet range, depending on whether users need to interact with the data inside the form.

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.