Listbox Keeps Moving Down

[Justinian]

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.

 

[mrmmickle1]

Try looking at this this Microsoft Excel Team Blog Post: CLICK HERE

 

[Justinian]

Sorry, I am now on Excel 2016. Will this still apply?

 

[mrmmickle1]

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/office-update-breaks-activex-controls/

 

[Justinian]

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?

 

[mrmmickle1]

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....

 

[Justinian]

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.