ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box Control Strange Behavior (https://www.excelbanter.com/excel-discussion-misc-queries/230780-combo-box-control-strange-behavior.html)

Tom McCray

Combo Box Control Strange Behavior
 
Using the VBA control -

90% of the time all is well, but occassionally some of the combo boxes will
automatically 'resize' when I click on them. It looks like some kind of
'bug' in the control itself (the width and height change, and the font inside
the control (the actual text) gets very small, but the font (when viewed with
properties inside VBA) is still Arial 10).

I'm NOT doing any VBA to programmatically alter the size.

It's important that these things work properly, as I'm trying to build an
interactive form for users to input data; this will be a big problem.

Anyone seen this behavior?? (I should say that I'm using Remote Desktop, to
work on this occasionally, but I have seen this when NOT in a RDP session).

Thanks in advance...

HelpExcel.com[_2_]

Combo Box Control Strange Behavior
 
Tom,

I have seen this behaviour. I had to code the sizes for one of my clients
because they kept re-sizing.
--
Regards,
Eddie
http://www.HelpExcel.com


"Tom McCray" wrote:

Using the VBA control -

90% of the time all is well, but occassionally some of the combo boxes will
automatically 'resize' when I click on them. It looks like some kind of
'bug' in the control itself (the width and height change, and the font inside
the control (the actual text) gets very small, but the font (when viewed with
properties inside VBA) is still Arial 10).

I'm NOT doing any VBA to programmatically alter the size.

It's important that these things work properly, as I'm trying to build an
interactive form for users to input data; this will be a big problem.

Anyone seen this behavior?? (I should say that I'm using Remote Desktop, to
work on this occasionally, but I have seen this when NOT in a RDP session).

Thanks in advance...



All times are GMT +1. The time now is 12:44 PM.

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