UserForm Command Bar

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Gg251544.dbarvbe_ZA01201595(en-us,office.14).gif

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. You can select the Show ToolTips option in the General tab of the Options dialog box if you want to display ToolTips for the toolbar buttons.

Toolbar Buttons

Gg251544.tbr_bfrt_ZA01201680(en-us,office.14).gifBring To Front

Moves the selected objects to the front of all other objects on a form.

Gg251544.tbr_sbak_ZA01201737(en-us,office.14).gifSend To Back

Moves the selected objects behind all other objects on a form.

Gg251544.tbr_grp_ZA01201704(en-us,office.14).gifGroup

Creates a group of the selected objects.

Gg251544.tbr_ugrp_ZA01201760(en-us,office.14).gifUngroup

Ungroups the objects that were previously grouped.

Align

  • Gg251544.tbr_all_ZA01201672(en-us,office.14).gif Lefts — Aligns the horizontal position of the selected objects, putting the left-most edges in line.

  • Gg251544.tbr_alc_ZA01201671(en-us,office.14).gif Centers — Aligns the horizontal position of the selected objects, putting the centers in line.

  • Gg251544.tbr_alr_ZA01201674(en-us,office.14).gif Rights — Aligns the horizontal position of the selected objects, putting the right-most edges in line.

  • Gg251544.tbr_alt_ZA01201675(en-us,office.14).gif Tops — Aligns the vertical position of the selected objects, putting the tops in line.

  • Gg251544.tbr_alm_ZA01201673(en-us,office.14).gif Middles — Aligns the vertical position of selected objects, putting the middles in line.

  • Gg251544.tbr_alb_ZA01201670(en-us,office.14).gif Bottoms — Aligns the vertical position of the selected objects, putting the bottoms in line.

  • Gg251544.tbr_altg_ZA01201676(en-us,office.14).gif to Grid — Aligns the top left of the selected object to the closest grid. The object is not resized.

Center

  • Gg251544.tbr_cenh_ZA01201684(en-us,office.14).gif Horizontally — Centers the selected objects horizontally.

  • Gg251544.tbr_cenve_ZA01201685(en-us,office.14).gif Vertically — Centers the selected objects vertically.

Make Same Size

  • Gg251544.tbr_swid_ZA01201752(en-us,office.14).gif Width — Adjusts width.

  • Gg251544.tbr_sht_ZA01201744(en-us,office.14).gif Height — Adjusts height.

  • Gg251544.tbr_sbth_ZA01201738(en-us,office.14).gif Both — Adjusts both the width and the height.

Gg251544.tbr_zoom_ZA01201769(en-us,office.14).gifZoom

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