How can I move or resize drop down box?

  • Thread starter Thread starter CaRT6128
  • Start date Start date
C

CaRT6128

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.
 
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
 
Back
Top