Text resizes in combo box when "Move and size with cells" set
I googled for an answer to my problem and interestingly exactly
the same question was asked in Feb 2002. Omminoustly there
were no answers so I thought I would give it another try...
I'm using Excel 2002/3.
"I've got a list of comboboxes in a sheet, one per row. In the property
dialog for the comboboxes, I chose "Move and size with cells" because
another column in each row is set to wrap, expanding in height as the
text grows. I'd like the combobox to grow in height as well. This
works, however the text in the combo also expands in height, making it
look pretty ugly. I can't find a property in the combo's property
sheet or in code to effect the font height."
Many thanks,
Roy
|