Resize a data valication drop down box?
 

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?

Resize a data valication drop down box?
 

In short you can't increase the size...
--
HTH...

Jim Thomlinson


"Dave" wrote:

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?

Resize a data valication drop down box?
 

DV list dropdowns cannot be re-sized

You could try a ComboBox instead.


Gord Dibben MS Excel MVP

On Fri, 8 Aug 2008 08:03:02 -0700, Dave
wrote:

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?