Results 1 to 3 of 3

Thread: Excel ListBox Increases Hight

  1. #1
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013

    Excel ListBox Increases Hight



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a ListBox in my Excel ActiveX userform which list the results of each search. This box has both horizontal and vertical scroll bars and in the properties has column bound 1 and column count 15. It works well but after each search it increases its high a bit towards the bottom of the screen regardless if the viewing area shows 1 record or 10 and keeps increasing after each search covering some other control buttons I have below

    Is this problem due to a setting I missed in the properties or perhaps in the code?

  2. #2
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    376
    Articles
    0
    Excel Version
    2020
    Integralheight=false

  3. #3
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013
    Thanks so much snb, it worked

Posting Permissions

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