Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listbox behaviour (Xl 2002)

    When I change the backcolor property of my listbox or when I insert one row inside the worksheet, the listbox size increases each time !!!
    It's quite annoying as I'm looking for a professional lay-out in this workbook...Please help,
    where from comes such behaviour??? How can I stop it? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Thanks

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

    Re: Listbox behaviour (Xl 2002)

    I'm using the Dutch language version of Excel 97; the wording of items may be different in English Excel 2002. Also, behavior of controls may have changed, so the following may not be entirely correct.

    Make sure you are in design mode.

    (1) Right click the listbox and select Format Object. The third tab in the dialog has options for moving and resizing the object with cells. You probably want the option where the object is neither moved nor resized.

    (2) Right click the listbox and select Properties. If the IntegralHeight property is set to True, the listbox will resize itself so that an integral number of rows is displayed. This should happen only once, however.

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listbox behaviour (Xl 2002)

    Hans,

    The problem was solved thanks to your second remark (setting the IntegralHeightProperty to FALSE) <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> !
    The first one, "format object as neither moved and sized with cells" was without effect (Anyway, my row insertion test was largely under the cells covered by the listbox).

    What is strange is that my listbox (in the very same workbook) behaves very well both in Excel 2000 and 97.
    The problem occurs only in excel 2002.

    Another question.
    Is there a limitation in the number of listboxs on a same worksheet?
    In keep this question in this thread as at the beginning I had the same auto-expanding behaviour with two listboxes, and I tried to work around replacing the second listbox by a few radio buttons. Then, the radio buttons stay stable but the remaining first listbox was still strangely oversizing itself ...so my post.

    Thanks very much Hans

Posting Permissions

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