Adjust Spacing for Controls
In Forms Designer, select the controls for which you want to adjust the spacing.
On the Developer tab, in the Arrange group, click Align, point to Distribute Horizontally or Distribute Vertically, and then click one of the following.
Click | To |
---|---|
Make Equal | Make all horizontal and vertical spaces between controls the same size. The amount of horizontal and vertical space will vary based on the area that is available to show the controls and the combined width of all controls. |
Increase | Increase the space between controls by one grid block . |
Decrease | Decrease the space between controls by one grid block. |
Remove | Remove the space between controls. The controls don't overlap, but are immediately adjacent to each other. |
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.