ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Embedded Combo box changes size (https://www.excelbanter.com/excel-programming/416746-embedded-combo-box-changes-size.html)

IanC

Embedded Combo box changes size
 
I have embedded some combobox controls on an basic worksheet, and set up the
layout for my screen resolution of 1280x1024. All is working well. However,
if I change the screen resolution (say 1024x768) the boxes increase in size
and overlap.

Then, every time I use a box it grows in size again. Is there any way to
keep the layout consistent regardless of screen resolution, as was (broadly)
the case with Forms?

If I build the boxes in the 1024x768 resolution and then use the boxes in
the higher resolution, the boxes stay the same size, but the font gets
smaller every time I use it, despite the properties window saying that it has
not changed.

Thanks in advance

IanC

p.s. I have set the properties to "Do not size with cells"


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com