You created the ListBoxes using the Control Toolbox?

Hit design mode icon, select the listbox and re-size it.

Hit design mode icon again.


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 05:23:03 -0700, William
wrote:

I created several drop down list boxes to limit entries in several fields in
a worksheet. Two fields are limited to "YES" and "NO." When I click on the
down arrow which makes the list pop up, it is a good 3-4" wide, with the YES
and NO at the far left of the box. It is quite annoying to have to move the
mouse so far to click the appropriate choice. Is there some way to limit the
width of the drop down box?

Thanks for ideas.