The size of the ActiveX ListBox control shrinks

  • Thread starter Thread starter Rob Flott
  • Start date Start date
R

Rob Flott

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
 
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
Click to expand...

in the properties try changing the integralheight to "False", I had a
similiar problem and that worked for me
 
in the properties try changing the integralheight to "False", I had a
similiar problem and that worked for me- Hide quoted text -

- Show quoted text -
Click to expand...

Angus, Thank you...that worked...
 
Back
Top