List Size

Hi,

I have created an Excel workbook. Within this workbook I have created a drop down list through Data Validation, for staff to choose the relevant entry. Most of the lists width, fit the size of the cell but on a couple of lists the drop down selection choice cover 3 cells. Some of the lists are only offering the choice of 'yes or 'no'.

Any ideas please how I can resize the list.

Hi Jackie,

Does this fix it for you?

See if links help

http://www.contextures.com/xlDataVal08.html#Wider

http://www.contextures.com/xlDataVal08.html#Larger

VBA Noob