Results 1 to 2 of 2

Thread: Combo Box

  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need a drop down list in an Excel 2003 spreadsheet so that I can choose from a list of names. I've created a combo box which works fine except that it doesn't grow or shrink when the row grows (or shrinks). How do I make the combo box stay in the cell just like it is (or resize when the cell gets taller or wider)?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The easiest way to create a dropdown list is through Data | Validation..., with List as Allow option.

    A combo box (dropdown list) from the Forms toolbar does not have a setting to be resized automatically.

    A combo box (dropdown list) from the Control Toolbox can be set to resize:
    - Make sure that you're in Design Mode (the first button on the Control Toolbox is "on").
    - Right-click the combo box.
    - Select Format Control... from the popup menu.
    - Activate the Properties tab.
    - Select "Move and size with cells".
    - Click OK.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •