PDA

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.