Mike,
Regarding #2:

You select all controls, then choose the action.

When you select several controls, resize handles appear on each of the
controls selected. The handles on the last one selected are a different
color than the rest. The other controls will be modified to match this one.
On my installation of Excel 2002, the "primary" handle color is white,
while the others are black. If you Align Left, all selected controls will
align to the primary control.

If you drag to select a group of controls and the wrong one ends up being
primary, hold down Crtl while twice clicking the control you want to make
primary - once will remove it from the selection, the second will add it
back as the last selection (but avoid the double-click which will take you
to code). Ctrl allows you add individual controls to a selection in the same
way it allows you to add individual list items to a selection.

Bob Kilmer

"Mike NG" wrote in message
...
Problem 1
I made my userform deeper, and I wanted to shuffle everything down to
make way for a new field. I selected all fields and dragged them down.
However this had the effect of duplicating everything even though the
Undo menu said "undo move" after the operation

Problem 2
I can't find any consistency in how "align" works. If you have 4
higgledy piggledy arranged vertical fields and you want to say left
align everything to the one that's second from the top, do you highlight
that one first, followed by the rest, and then click align, or doesn't
it work like that
--
Mike