Alignment of Combo Boxes

  • Thread starter Thread starter Shari
  • Start date Start date
S

Shari

After creating a template form in Excel with multiple combo boxes I have
discovered they are not uniform ( inline, straight). Can someone
suggest a quick easy way to align the combo boxes on my form?

Thanks- Shari in PA.
 
If you hold down the Alt key on the keyboard as you create the combobox, it
will "snap" to the corners of the cells on the sheet. The Alt key also snaps
the object if you're moving it after it's been created, or if you are
resizing it. (Sometimes, changing the magnification to 200% or greater can
be helpful because it gives you the extra handles for horizontal sizing
where they may not show if the cell isn't big enough.)

Holding down the Ctrl key causes resizing to be about the center of an
object.

Holding down the Shift key as you drag an object causes it to move only in
one direction at a time (vertical or horizontal).

You can experiment with combinations of the three; for example, Shift and
Alt would allow you to move horizontally across the sheet, and only allow it
to stop at the corners of cells.

Another item to be aware of is the object positioning properties, available
by right-clicking the object and selecting the Properties tab. This allows
you to decide how the object responds to changes in the underlying cells of
the sheet.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top