View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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