Formatting Form Controls

  • Thread starter Thread starter MH
  • Start date Start date
M

MH

I added a drop-down list to my worksheet. I'd like to
resize its height so that it fits the height of the cell
it's in. I went into the Format Control Properties and
clicked on the Size tab. I changed the height there, but
the drop-down list box is still taller than my cell
height. Isn't there a way to have the drop-down list box
fit the cell?

In the Format Control properties, I clicked on the
Properties tab and see that the option "Move and Size with
Cells" is greyed out. I assume this is the option I'd
select to do what I want?

Can someone pls help me? Thanks.
 
M,

The height is that of the combo box when it's not open. The ListRows
property determines the height of the drop-down, by determing how many items
to list when it's dropped down (dropdowned?). The height of your cell must
be able to accomodate that.
 
Back
Top