I've read many of the post regarding check boxes and have tried some of the
macros. I still cant seem to line up multiple boxes evenly. I end up zooming
to 200 and manually doing it. I've even tried the draw tab to align, but only
get one way.

Hi,

Here's a neat trick. If the checkboxes are from the 'Control' toolbox then
they must be in design mode.

Enable the 'drawing' toolbar "View|Toolbars" and you'll see a white arrow.
Drag a box around all the checkboxes and they become selected. then on the
drawing toolbar click:-

Draw|Align or distribute and then whichever alignment you want.

Mike



"doss04" wrote:

I've read many of the post regarding check boxes and have tried some of the
macros. I still cant seem to line up multiple boxes evenly. I end up zooming
to 200 and manually doing it. I've even tried the draw tab to align, but only
get one way.

If they are from the Control toolbar, you can right click any one of them
and select Properties from the popup menu that appears. You can then set the
Top and Left properties as desired. Leaving the Properties window open and
selecting a different CheckBox will allow you to set its Top and Left
properties as desired. Of course, you can do that for any control from the
Control toolbar and, of course, set any of the other properties as well.

However, there is a shortcut trick available here as well. You have to
display the Properties window by right-clicking an individual control as
described above. Once you have the Property window displayed, either
Shift-click or Ctrl-click on each CheckBox one at a time. This will allow
you to select multiple controls at once AND the properties window will
change to offer you "common" properties to all the selected controls. Change
a property value in the Properties window and it will be applied to *all*
the selected controls. So, as an example, enter 30 into the Top property and
watch all the selected controls move to that same Top coordinate.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

Here's a neat trick. If the checkboxes are from the 'Control' toolbox then
they must be in design mode.

Enable the 'drawing' toolbar "View|Toolbars" and you'll see a white arrow.
Drag a box around all the checkboxes and they become selected. then on the
drawing toolbar click:-

Draw|Align or distribute and then whichever alignment you want.

Mike



"doss04" wrote:

I've read many of the post regarding check boxes and have tried some of
the
macros. I still cant seem to line up multiple boxes evenly. I end up
zooming
to 200 and manually doing it. I've even tried the draw tab to align, but
only
get one way.