The Userform Toolbar

When you’re working with userforms, don’t forget about the Userform toolbar in the VBE.

Uftb1

It has some handy tools on there, particularly for lining up controls. Here’s a userform with four checkboxes on it.

Uftb2

The same form after using the Align Lefts and Make Width Same Size buttons. (This sounds like a commercial for detergent.)

Uftb3

In Access, you can use the Control and Shift keys in combination with the Arrow keys to move and resize controls. As far as I know, there’s nothing similar for Excel userforms. It sure would be nice, though.

Posted in Uncategorized

5 thoughts on “The Userform Toolbar

  1. I have that docked with the MZTools commandbar, and I also customized it a bit… took out the zoom combobox, and put there the spacing controls (Horizontal and Vertical), which are the ones that I use a lot !

    Definitely a useful toolbar !

  2. Lately I’ve been trying to teach myself VB.NET. I really like the editor but one thing bugging me was that the right-click menu does not offer Align choices for form controls as it does in the VBE.
    On reading your post I looked in the .NET editor for a similar toolbar. There is one, in fact it’s been there all along at the top of the screen, and it has all those choices. Who knows how long before I would have noticed it without your suggestion (yes, I’m in way over my head with VB.NET).

    Thanks.

  3. Dick: In response to your question to ross I nosed around and found the “Align or Distribute” toolbar:
    Application.CommandBars(“Align or Distribute”).Visible = True
    It has most of the same controls, but not the “Make Same Size.”


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.