View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zilla[_2_] Zilla[_2_] is offline
external usenet poster
 
Posts: 51
Default Width of drop-down list

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.

--
- Zilla
(Remove XSPAM)