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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop-down listbox disappeared 2
Making Drop Down Box Visible with Excel 2003 2
Drop Down--How do I copy and update cell link/input range 1
Create Drop Down Box populated by a List 1
Comments boxes resizing 3
Drop down box 5
Select from drop-down box before moving on 1
Drop down / validation / lookup into the same cell 2

Back
Top