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

[Guest]

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]

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?

 

[Debra Dalgleish]

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

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