Format

This menu contains commands for designing and arranging controls on a UserForm.

alt text

Align - Displays a submenu of commands for aligning multiple UserForm controls. This menu contains the commands: Lefts, Centers, Rights, Tops, Middles, Bottoms, to Grid. This is only available when you have a userform selected.
Make Same Size - Displays a submenu of commands for sizing multiple UserForm controls. This menu contains the commands: Width, Height, Both. This is only available when you have a userform selected.
Size to Fit - Changes the height and width of an object to fit its contents.
Size to Grid - Adjusts the height and width of the selected object to fit the nearest gridlines in the form. You can change the size of your grid on the General tab of the Options dialog box.
Horizontal Spacing - Displays a submenu of commands for adjusting the horizontal spacing between multiple UserForm controls at once. This menu contains the commands: Make Equal, Increase, Decrease, Remove.
Vertical Spacing - Displays a submenu of commands for adjusting the vertical spacing between multiple UserForm controls at once. This menu contains the commands: Make Equal, Increase, Decrease, Remove.
Center in Form - Displays a submenu of commands for centring one or more selected UserForm controls on a UserForm's central axes. This menu contains the commands: Horizontally, Vertically.
Arrange Buttons - Displays a submenu for arranging one or more selected buttons along the bottom or edge of a UserForm. This menu contains the commands: Bottom, Right.
Group - Creates a group of the selected objects which can then be moved and formatting as a single unit.
Ungroup - Ungroups the objects that were previously grouped.
Order - Displays a submenu for altering the order of a selected UserForm control. This menu contains the commands: Bring To Front, Send To Back, Bring Forward, and Send Backward.


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext