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

Text resizes in combo box when "Move and size with cells" set
 

are the comboboxes from the forms toolbar or control toolbox toolbar?

--
Regards,
Tom Ogilvy


"RzB" wrote:

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

Text resizes in combo box when "Move and size with cells" set
 

Tom,

From the Control Toolbox.

Thanks,
Roy

Text resizes in combo box when "Move and size with cells" set
 

As you can see it's looks really bad. Also the drop down
list is unusable in this state.

See screen shots here....

http://tinyurl.com/3arhkr

Roy


"RzB" wrote in message
...
Tom,

From the Control Toolbox.

Thanks,
Roy