You can't control the data validation list width -- it's controlled by
the column width. You can use programming to make the column temporarily
wider. There's sample code he

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

Zilla wrote:
First off, thanks for answering all my (numerous) questions!
Now this one...

I have Validation on a cell against a list. However the
width of the List entries are wider than the width of
the cell, hence the rhs of the list is cropped, rendering
it useles in this case. I don't want to adjust the width
of the cell.

Can I adjust the width of a drop-down list so it shows
all the chars. I have, regardless of how wide the cell
is I have the Validation on against the list? Once the
user chooses from the list, the original width of the
cell persists.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html