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