Dropdown box (Excel 2000)

Topic

New Reply

I’ve created a dropdown box using Data Validation, and it shows the valid entries for a cell. But the dropdown box isn’t quite long enough, and you have to scroll to see all the choices. How do I make the dropdown box a little longer, so all the entries show? This isn’t an ActiveX control or anything like that, just the Data Validation list of choices.
Thanks,
Charlie

Reply | Quote

Replies

The length of the dropdown list for Validation isn’t configurable. See if you can use the combo box from the Forms toolbar. Put it over the linked cell. you can set the number of drop down lines by right clicking the combo box and selecting Format Control, Control tab.

Reply | Quote

The length of the dropdown list for Validation isn’t configurable. See if you can use the combo box from the Forms toolbar. Put it over the linked cell. you can set the number of drop down lines by right clicking the combo box and selecting Format Control, Control tab.

Reply | Quote