Combo Box changes

[RobT]

I am using Excel X for Mac SR1, Mac OS10.4.4

I have created some Combo Boxes from the Forms Toolbar and want to
change some of the characteristics.

1. The height of the box, seems to be stuck on 0.67cm. I change it in
Format Control/Sizes but it reverts to 0.67cm as soon as I hit OK.
Click dragging does not work. I am able to change the width by both
methods.

2. Font size, type, colour.

Thanks.

 

[JE McGimpsey]

1. The height of the box, seems to be stuck on 0.67cm. I change it in
Format Control/Sizes but it reverts to 0.67cm as soon as I hit OK.
Click dragging does not work. I am able to change the width by both
methods.

Forms toolbar comboboxes are, in the XL Object model, really Dropdown
objects. Unfortunately, the U/I method to change the height doesn't work.

However, if you use the Visual Basic Editor you can:

1) Type OPTION-F11 to enter the VBE
2) Type CMD-G to open the Immediate Window
3) Type or paste

ActiveSheet.Dropdowns(1).Height = X

in the Immediate Window, where X is your desired height in points (0.67
cm is about 19 points).

2. Font size, type, colour.

AFAIK, you can't change font size or color, nor can you change the color
of the dropdown itself. I'm not sure what you mean by "type", but I
expect that's not changeable either.