Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Listbox Keeps Moving Down

  1. #1
    Board Regular
    Join Date
    Aug 2009
    Location
    The OC, where else?
    Posts
    1,236
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Listbox Keeps Moving Down

    I have a listbox with employee names. Every time I save my workbook, close, and reopen, the listbox keeps moving down slightly. How can I stop this from happening.
    I am using the beautiful Excel 2016!

  2. #2
    Board Regular mrmmickle1's Avatar
    Join Date
    May 2012
    Location
    Charlotte, NC
    Posts
    2,453
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    Try looking at this this Microsoft Excel Team Blog Post: CLICK HERE
    Matt Mickle
    Microsoft MVP - Excel
    Using Excel & Access 2010, 2013 & 2016 | Windows 7 | 64 Bit

    Post a screen shot with the MrExcel HTML Maker Add-In or the Excel Jeanie Add-In

  3. #3
    Board Regular
    Join Date
    Aug 2009
    Location
    The OC, where else?
    Posts
    1,236
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    Sorry, I am now on Excel 2016. Will this still apply?
    I am using the beautiful Excel 2016!

  4. #4
    Board Regular mrmmickle1's Avatar
    Join Date
    May 2012
    Location
    Charlotte, NC
    Posts
    2,453
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    I haven't experienced the issue in 2016. I've only had issues in 2010 and 2013.

    Here's another link that may be of interest: http://excelmatters.com/2014/12/10/o...ivex-controls/
    Last edited by mrmmickle1; Sep 27th, 2016 at 04:45 PM.
    Matt Mickle
    Microsoft MVP - Excel
    Using Excel & Access 2010, 2013 & 2016 | Windows 7 | 64 Bit

    Post a screen shot with the MrExcel HTML Maker Add-In or the Excel Jeanie Add-In

  5. #5
    Board Regular
    Join Date
    Aug 2009
    Location
    The OC, where else?
    Posts
    1,236
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    These only appear applicable to objects that change before or after print preview. Would that apply to me since my problem only occurs after saving?
    I am using the beautiful Excel 2016!

  6. #6
    Board Regular mrmmickle1's Avatar
    Join Date
    May 2012
    Location
    Charlotte, NC
    Posts
    2,453
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    Would that apply to me since my problem only occurs after saving?
    Not positive. Did you search for the .exd files in the directory specified in the Excel Matters Article?

    After a quick search I just found one on my system.

    In the past I've used Form Controls in place of ActiveX Controls to avoid the control resizing issues. Before resorting to this I tried a few other things like Resizing and re-positioning controls on WorkBook_Open() etc....
    Matt Mickle
    Microsoft MVP - Excel
    Using Excel & Access 2010, 2013 & 2016 | Windows 7 | 64 Bit

    Post a screen shot with the MrExcel HTML Maker Add-In or the Excel Jeanie Add-In

  7. #7
    Board Regular
    Join Date
    Aug 2009
    Location
    The OC, where else?
    Posts
    1,236
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Listbox Keeps Moving Down

    None of the hotfixes worked because my system is not compatible (Win10, 64-bit). I am hesitant to play around in my registry so for now, I just used a form control listbox as you suggested.

    Thank you for your time.
    I am using the beautiful Excel 2016!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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