The size of the ActiveX ListBox control shrinks
 

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

The size of the ActiveX ListBox control shrinks
 

On May 24, 5:28*pm, Rob Flott wrote:
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

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

The size of the ActiveX ListBox control shrinks
 

On May 25, 8:43*am, Angus Beaumont wrote:
On May 24, 5:28*pm, Rob Flott wrote:





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

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 -

Angus, Thank you...that worked...