Use Combobox List Instead Of Data Validation Dropdown List

[regc]

Hello

Depending on the finished worksheet I find that sometime the data validation list becomes almost unreadable due to size of letters.If I require a control form button such as a combobox will that work as well in the same way as a DV dropdown list?
How do i use a combobox for the dropdown menu instead of a DV dropdown menu

Can this be done

Regards
RegC

[alansidman]

Here is a link to a Debra Dalgleish tutorial on using a combo box instead of DV. Good luck with your project.
I have also change your combo box in the attached to an Active X linked to the appropriate cells as Debra explained.

Alan

Combo Box Drop Down for Excel Worksheet « Contextures Blog (http://blog.contextures.com/archives/2010/11/10/combo-box-drop-down-for-excel-worksheet/)

[regc]

Thanks Alan