Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Size of Combo Box (Excel 2003)

    I have a user who has some combo boxes on a spreadsheet. When he demonstrates to his team via a projector, each time he makes a selection from a combo box, the size of the box shrinks - even when he demonstrates it without a projector it happens. This is embarrassing to him and I was asked to find out what is going wong here. I have looked at the properties of the combobox and seen nothing out of order.
    Does anybody have any idea what is going on here and how to fix it?

    Thank you for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Size of Combo Box (Excel 2003)

    Can you tell us whether these combo boxes have been created from the Forms toolbar or from the Control Toolbox? Thanks.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Size of Combo Box (Excel 2003)

    He says from the control toolbox.
    Thanks Hans.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Size of Combo Box (Excel 2003)

    I can't find anything relevant. He could check the following:
    - Switch to design mode using the first button on the Control Toolbox.
    - Click on the combo box.
    - Select Format | Control...
    - Activate the Properties tab.
    - If Object Positioning is set to Move and Size with cells, select one of the other two options.

    If that doesn't help, he might consider using a combo box from the Forms toolbar, or Data | Validation based on a list. Which, if any, can be used depends on the situation.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Size of Combo Box (Excel 2003)

    Someone else solved a remotely similar problem with a Button control recently by setting it Placement property to 1. It might be worth a try.
    Legare Coleman

  6. #6
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Size of Combo Box (Excel 2003)

    Thanks - we will try that.

  7. #7
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Size of Combo Box (Excel 2003)

    Thanks, we have treid the suggestion - did not wok. He does not want to use your 2. suggestion, although I have made that work very nicely.

    Thank you for your good suggestions.
    itconc

Posting Permissions

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