View Full Version : strange with excel 2010
jack nt
11-14-2012, 09:01 PM
please see the attached
it's normal with excel 2003 and 2007 but strange with excel 2010:
when the widths of cboA and cboB change the same, cboA keeps its height while height of cboB change too.
who kowns why and how to settle?
Bob Phillips
11-15-2012, 12:48 AM
You have the aspect ratio of B locked, so widening it makes it taller as well. A is not locked.
Go into design mode, right-click on B, and o the size tab, unlock it.
jack nt
11-15-2012, 02:56 AM
You have the aspect ratio of B locked, so widening it makes it taller as well. A is not locked.
Go into design mode, right-click on B, and o the size tab, unlock it.
thank xld
it seems not belong to locked or unlocked. (nothing happens with xls 2003 and 2007)
jack nt
11-16-2012, 08:05 PM
More information:
combobox A was created with design mode
while combobox B was created with VBA (OLEObjects.Add)
Bob Phillips
11-17-2012, 01:53 AM
I thought my post explained it.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.