View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IanC IanC is offline
external usenet poster
 
Posts: 49
Default 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"