Combobox

D

David Fixemer

My combobox works great until it is resized with the rows
and columns, then the text on the inside is a "scale"
version of the original. Is there anyway this can be made
a certain font irregardless of the row height and column
width (i.e. irregardles of the combobox size?)

Sincerely,

David Fixemer
 
G

Greg Wilson

Can you not unselect the "Move and size with cells" option
and either not let it change size with the columns/rows or
alternatively size it programmatically? You will of
course have to devise some means of executing this code.
There is no "ColumnResize" event.

Sizing a combobox programmatically apparently does NOT
effect the font. The following statement in my experiment
had no effect on the font of a combobox placed on the
active sheet. I repeatedly changed the size of Column "E"
and ran the code:
ActiveSheet.OLEObjects(1).Width = Columns("E").Width

Sorry, it's the best I can offer.

Regards,
Greg
 
Top