Lining up checkboxes.

[Serum]

I'm wondering if there is a way to automatically line up checkboxes.

Manually is a pain, especially when I need a lot of them. Anyone kno
a quick way to line them up vertically or horizontally so they loo
neat?

Thanks in advance

 

[Dick Kusleika]

Serum

On a userform? See here
http://www.dicks-blog.com/excel/2004/09/the_userform_to.html

I don't know how to do it on a worksheet, other than a macro.

 

[jeff]

Hi,

The only way I have had anything close is to copy
one and hold the shift and ctrl key as I drag
to the new position. But that (holding the shift key)
only helps for one direction. It's tough.

jeff

 

[Debra Dalgleish]

On a worksheet --

For checkboxes from the Forms toolbar:
Hold the Shift key, and click on each checkbox to select it
OR, use the Select Objects tool on the Drawing toolbar to
select multiple checkboxes at once
On the Drawing toolbar, choose Draw>Align or Distribute>
Align Left

For checkboxes from the Control toolbox:
Open the Control Toolbox, and enter Design mode
Hold the Shift key, and click on each checkbox to select it
OR, use the Select Objects tool on the Drawing toolbar to
select multiple checkboxes at once