Resize a data valication drop down box?

D

Dave

I have a large number of variables that I display in a drop down from a data
validation list. The shorter lists display fine. The longer lists
automatically provide the scroll bar. All of that is great. I have a couple
of lists that could be displayed without the scroll bars if I was able to
incrase the length of the drop down box. How can I do that?
 
G

Gord Dibben

DV list dropdowns cannot be re-sized

You could try a ComboBox instead.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
list or combo box 0
drop box/data validation help 0
Filtered drop down list 2
Help with drop down selection and populating related data... 9
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Combo box 0
Print Macro w/drop down list 1

Top