View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Validation List advise....

Dermot,
To get a blank, simply put a blank cell in your validation
list i.e. if validation list is cell c1:c10, make c1 =blank or c10 =blank (or
any other!)

Yes, you can program a validation process but details are required if you
want sample code.

Width of validation list = column width so increase column width

HTH

"Dermot" wrote:

If I create a validation list, with an option Yes, the text "Yes" appears in
the relevant cell.How do I create an option in the validation list to return
it to a blank cell with no text.
1. Can you program a full validation list instead of using Data | Validation
List?
2. Is there a way to increase the width of the Validation List dropdown to
accomodate longer words?

Thanks