How to align check boxes on an Excel sheet?

[CC]

I am creating an Excel form with check boxes. I cannot align the boxes in
the column. I tried Snap > to Grid and Align and Distribute (which remained
gray) in the Draw toolbar. The boxes didn't budge.
Any suggestions?
Thanks,
CC

[Biff]

Hi!

Are these checkboxes on a worksheet or on a user form?

If they're on a worksheet get the first one aligned the
way you want it and then just copy and paste to other
cells as needed. The alignment/placement of the first
checkbox will be copied to the other cells making exact
alignment a snap.

Biff

>-----Original Message-----
>I am creating an Excel form with check boxes. I cannot
align the boxes in
>the column. I tried Snap > to Grid and Align and
Distribute (which remained
>gray) in the Draw toolbar. The boxes didn't budge.
>Any suggestions?
>Thanks,
>CC
>.
>

[CC]

Thanks Biff! That looks 100% better.
CC

"Biff" wrote:

> Hi!
>
> Are these checkboxes on a worksheet or on a user form?
>
> If they're on a worksheet get the first one aligned the
> way you want it and then just copy and paste to other
> cells as needed. The alignment/placement of the first
> checkbox will be copied to the other cells making exact
> alignment a snap.
>
> Biff
>
> >-----Original Message-----
> >I am creating an Excel form with check boxes. I cannot
> align the boxes in
> >the column. I tried Snap > to Grid and Align and
> Distribute (which remained
> >gray) in the Draw toolbar. The boxes didn't budge.
> >Any suggestions?
> >Thanks,
> >CC
> >.
> >
>