Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

The size of the ActiveX ListBox control shrinks

109 views
Skip to first unread message

Rob Flott

unread,
May 24, 2012, 12:28:39 PM5/24/12
to
I am unable to maintain a set size of the ActiveX Listboxes on my
Excel worksheet.

In Properties I set the size of each to a height of 40 and width of
240 and use the font Arial-Regular-14

After saving the file and then re-opening the sizes change to a height
of 22.5 and width of 148.5

Is there a way to lock the size so it does not change? In Properties
I have 'Locked' set at 'True'.

I appreciate any help with this issue. Also if you could direct me to
where I can learn more about the Properties of ActiveX Controls.

Thank you

Angus Beaumont

unread,
May 25, 2012, 11:43:10 AM5/25/12
to
in the properties try changing the integralheight to "False", I had a
similiar problem and that worked for me

Rob Flott

unread,
May 25, 2012, 12:38:53 PM5/25/12
to
> similiar problem and that worked for me- Hide quoted text -
>
> - Show quoted text -

Angus, Thank you...that worked...
0 new messages