Increase Size of Drop Down Menu Box

[smokeydawson555]

I have created a list and am using data validation to create a drop down list based on the text in this list. However some list entries are quite long and they do not fit in the default box size. Am I able to increase this box?

[martindwilson]

you might want to try a combo box instead see here
http://www.contextures.com/xldataval10.html