admin管理员组

文章数量:1129759

I’m using Excel 365 Version 2402. Everything works as expected in my macro-enabled Excel workbook, except my active-x ComboBoxes. I know this is a very old issue and there’s so much written about this topic that I’ve become quite confused. I can’t understand how such a simple problem is still occurring in the latest version of excel. I tried a lot of things but didn't help.

Now, let’s get to my issue:

The ActiveX ComboBoxes I’m using work correctly for days, but sometimes, unexpectedly, their size changes and their position shifts. Let me note this: all 3 ComboBoxes have exactly the same settings, but sometimes only one or two of them change size (they usually shrink and loose their correct positions). This problem occurs more often under the following conditions:

When opening the file on another company computer using the same Windows and Excel version, When changing the monitor, When connecting the computer wirelessly to a presentation screen, And sometimes even in other situations...

However, I can also go days without experiencing this issue.

I’ve ensured that the following settings are the same for all ComboBoxes:

Format Control: "Don't move or size with cells" is selected.
Properties: "AutoSize: False" is selected.

Despite all the effort I put into preparing this macro-enabled file, I recently faced this issue while presenting it to my team, and it made me quite anxious.

Does anyone have suggestions to help with this?

Please don’t suggest using Form-type ComboBoxes instead of Active-X because I want to take advantage of the additional features ActiveX ComboBoxes offer.And additionally my excel workbook shall be used in the company by several users, so I need a solution that I can apply on the workbook side.

本文标签：

版权声明：本文标题：combobox - Still getting randomly uncontrolled active-x control's resizing or repositioning problem in Excel MS 365 V 24 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736752294a1951098.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。