Skip to main content

UserForm toolbar

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 Moves the selected objects to the front of all other objects on a form.
Send To Back Moves the selected objects behind all other objects on a form.
Group Creates a group of the selected objects.
Ungroup Ungroups the objects that were previously grouped.
Align Lefts: Aligns the horizontal position of the selected objects, putting the left-most edges in line.

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

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

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

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

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

  To Grid: Aligns the top left of the selected object to the closest grid. The object is not resized.

Center Horizontally: Centers the selected objects horizontally.

Vertical  Vertically: Centers the selected objects vertically.

Make Same Size Width: Adjusts width.

  Height: Adjusts height.

  Both: Adjusts both the width and the height.

Zoom Reduces or enlarges the display of all controls on the UserForm. You can set any magnification between 10 and 400 percent.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>