Combobox
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
-----Original Message-----
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
.
|