Resize pulldown menu

[sreyes]

Can the pulldown menu be resized? I've seen it done but don't remember where so I think it's doable but don't know how or where. I do not want to change the cell size just the pulldown. I've seen it where the user can drag the corner of the pulldown to resize it.

Thank you,
~Sreyes

 

[Smitty]

Are you using a Data Validation drop-down?

If so the only way to resize is by using the View-->Zoom properties.

Debra Dalgliesh has a trick here though: http://www.contextures.com/xlDataVal08.html#Font

HTH,

 

[sreyes]

Isn't there a way to resize the pulldown but making some figure appear on the corner of the pulldown where the user grabs it with the mouse and then resizes the pulldown?

Thanks!!!

 

[Smitty]

If you use a Combo Box from the Forms toolbar the control can be resized, but I don't think you'd want to give users that ability.

 

[sreyes]

I am using a ComboBox to populate the pulldown. How can I resize the menu without changing the size of the cell?

Thanks!!
~Sreyes

 

[Smitty]

Since a ComboBox is an object that resides above the sheet you can make it whatever size you want without altering cells.

As for changing Data Validation drop downs, did you check the link I posted?

 

[sreyes]

Yes, I checked the link you provided. I agree with the website, it does make it appear 'jumpy'. I wanted just a resize of the pulldown by providing something where the user drags -or- something to resize the pulldown without actually having to change the font size.

Thanks again,
Sreyes