View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default using data validation list for dropdowns

If the list is not too long, I suggest to specify the choices directly in
the data validation dialog box. Instead of pointing to a range (which must
be on the same sheet), you can directly list your choices in the field
'Source' (must be comma delimited).

Cheers,

Joerg Mochikun


"Dean" wrote in message
...
A friend wants the list of potential choices to be on a different

worksheet
than where he is choosing the value, via data, validation, list. I told

him
to merely echo that list onto the current worksheet but he thinks that is
too inelegant!

It seems that EXCEL's help suggests if you somehow range name the list, it
can be on another worksheet, but it doesn't seem to work. Any

suggestions,
including simple techniques (non macro) other than data, validation, list?