I'm updating an old form. The drop down boxes are all set up and in the
correct cell, but they need to be moved over slightly, so they don't cover up
the word that's also in the cell. Anyone know a way to just scoot them over
a little?

If it was a box created from the Forms toolbar, you can hold Ctrl and then
click on the object to select it, and then use the arrow keys to move it.

If the box is an ActiveX object (created from the Control Toolbox) you'll
need to enter design mode (located on the Control Tool toolbar) to select the
box, and then you can use arrow keys.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CaRT6128" wrote:

I'm updating an old form. The drop down boxes are all set up and in the
correct cell, but they need to be moved over slightly, so they don't cover up
the word that's also in the cell. Anyone know a way to just scoot them over
a little?

Assuming a listbox from Control Toolbox you must enter design mode.

Then move to where you wish.

Toggle design mode is the Icon with the T-square and triangle.


Gord Dibben MS Excel MVP

On Tue, 25 Aug 2009 09:42:02 -0700, CaRT6128
wrote:

I'm updating an old form. The drop down boxes are all set up and in the
correct cell, but they need to be moved over slightly, so they don't cover up
the word that's also in the cell. Anyone know a way to just scoot them over
a little?