Increasing the size of the drop-down box

[EvansB2]

Hi there,

I am working in excel 2016 and wondered is it possible to increase the size of the drop-down box to match the size of the list in the box or even to make it bigger than it already defaults to? Or is it a pre-set size and can be adjsuted?

Any assistance would help and save me scrolling down with the mouse each time pick the name I need.

Regards

Ben

 

[ranman256]

if you are talking form drop box, set the properties:
set LISTROWS = N 'to see more rows
set COLUMNCOUNT = n 'to see more columns
set COLUMNWIDTHS = 123;233 'to get wider columns

 

[EvansB2]

Where are the properties in relation to drop box?

Regards

Ben

 

[My Aswer Is This]

What is a :

drop-down box​

Do you mean Data Validation list Box?

Or A Combobox?

 

[EvansB2]

I'm using a Data Validation list box.

 

[My Aswer Is This]

I'm using a Data Validation list box.

Increasing the size is not possible
Unless 2016 has something new.

That is unless someone else here knows of some complicated way of doing this.

I'm always afraid of saying nothing can be done.

 

[Scott T]

You could use a combo box and VBA

http://www.contextures.com/xlDataVal14.html