is there a way to enlarge drop down lists

[tropdoug]

I have looked all over for a solution to the ridiculously small layout of drop down lists, which often cuts off anything to the right of about 10 characters. Is there any way perhaps with VBA to expand the width of the drop down so that it shows the whole entry of a row.

 

[mikerickson]

What kind of drop down?
ActiveX, Forms menu, Validation, Userform?

 

[Jaafar Tribak]

If it is an activeX combobox then you can set the ColumnWidth Property to a value greater than the combobox width to display the Horizontal scrollbar.

If you don't want to have to horizontally scroll the combobox to see the whole entries then I can think of an API workaround to widen the dropdown. Let me know if you are interested.

 

[tropdoug]

Sorry I probably did not explain that well. If you have a large worksheet where the zoom factor is less than 100% then any drop down list created by using data validation becomes very hard to see. Is there a way when a user clicks on the list that the entries would 'zoom' back up to 100% and then revert to the custom size once the focus leaves the cell.

 

[Jaafar Tribak]

I don't think you can do that with a DV list. Maybe with a Listbox.