UserForm toolbar

Userform command bar

Contains buttons that are shortcuts to some commonly used menu items that are useful for working with forms.

You can click a toolbar button once to carry out the action represented by that button. If you want to display ToolTips for the toolbar buttons, you can select the Show ToolTips option on the General tab of the Options dialog box.

Button Icon Description
Bring To Front Toolbar buttons Moves the selected objects to the front of all other objects on a form.
Send To Back Send to back Moves the selected objects behind all other objects on a form.
Group Group Creates a group of the selected objects.
Ungroup Ungroup Ungroups the objects that were previously grouped.
Align Left Lefts: Aligns the horizontal position of the selected objects, putting the left-most edges in line.

Center  Centers: Aligns the horizontal position of the selected objects, putting the centers in line.

Right  Rights: Aligns the horizontal position of the selected objects, putting the right-most edges in line.

Top  Tops: Aligns the vertical position of the selected objects, putting the tops in line.

Middle  Middles: Aligns the vertical position of the selected objects, putting the middles in line.

Bottom  Bottoms: Aligns the vertical position of the selected objects, putting the bottoms in line.

Grid  To Grid: Aligns the top left of the selected object to the closest grid. The object is not resized.
Center Horizontal Horizontally: Centers the selected objects horizontally.

Vertical  Vertically: Centers the selected objects vertically.
Make Same Size Width Width: Adjusts width.

Height  Height: Adjusts height.

Both  Both: Adjusts both the width and the height.
Zoom Zoom Reduces or enlarges the display of all controls on the UserForm. You can set any magnification between 10 and 400 percent.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.