How do I change the width of the data validation list box?
 

I use data validation to select data entries. The width of the list box is
different in some worksheets. How do I control the width to expand when there
is longer text in the list range?

That box's width is determined by the width of the cell that has the
Data|Validation.

Can you widen the column?

Can you (ugh) merge some cells?

Davy Lawson wrote:

I use data validation to select data entries. The width of the list box is
different in some worksheets. How do I control the width to expand when there
is longer text in the list range?

--

Dave Peterson

Or, if you can use programming, you could use a SelectionChange event to
temporarily widen the column. There are some instructions he

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

Dave Peterson wrote:
That box's width is determined by the width of the cell that has the
Data|Validation.

Can you widen the column?

Can you (ugh) merge some cells?

Davy Lawson wrote:

I use data validation to select data entries. The width of the list box is
different in some worksheets. How do I control the width to expand when there
is longer text in the list range?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html