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
|