Groups
Groups
Sign in
Groups
Groups
microsoft.public.excel.programming
Conversations
About
Send feedback
Help
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
The size of the ActiveX ListBox control shrinks
109 views
Skip to first unread message
Rob Flott
unread,
May 24, 2012, 12:28:39 PM
5/24/12
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 AM
5/25/12
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 PM
5/25/12
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
> similiar problem and that worked for me- Hide quoted text -
>
> - Show quoted text -
Angus, Thank you...that worked...
0 new messages