Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox value | Excel Discussion (Misc queries) | |||
ComboBox | Excel Discussion (Misc queries) | |||
ComboBox or what?!? | Excel Programming | |||
combobox | Excel Programming |