Combo Box Resizes when clicked ... why?

[maporsche]

In Excel 2000, activeX controls such as command buttons,
combo boxes, check boxes and option buttons will display
inaccurately until they receive focus. Fonts and symbols
used in the control often appear distorted until clicked.
For example, with the combobox, the dropdown arrow
appears scrunched. With command buttons it looks like the
height and width are both increased by 1 when clicked and
then the button returns to the wrong size when another
control receives the focus. This occurs on multiple
machines running Office XP, with and without service
packs 1 and 2 installed. The problem does not occur in
Excel 97.

This is a weird and annoying little glitch and I would
love to hear about any possible solution

 

[peter Atherton]

Hello

You can create an initalize macro to set the focus when
the form loads. In design view click on the form and enter
the code

Private Sub UserForm_Initialize()
myCombo.setfocus
End Sub

This might fix the problem.

I presume that you have set the properties for the combo
box.

Regards
Peter

 

[C. A. Zanowick]

I have noticed this too with the MS Date and Time Picker Control 6.0 (SP4). It appears distorted when the file is opened but once you modify the window, click on the control, or scroll the control is rendered in a the proper size. Fortunately, I don't have any problems with the Combo boxes. They maintain their size consistently

I was wondering, Peter, if your code will do the same for me. Before coming upon this subject, I felt that if I could include some code to refresh the window when the file was opened it would take care of the problem. Would I have to use a different macro for my workbook, since I am placing only controls on the worksheets and not using the forms controls

Take care
Chris A. Z.