View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Agermose Jan Agermose is offline
external usenet poster
 
Posts: 3
Default caseinsensitive data validation

Im trying to set up a columnvalidation using a list. In the list I have DKK
and EUR but I would like for my users to be able to enter lowercase values
like dkk and eur. But it looks like I have to extend my list to include the
lowercase values? But this makes my dropdown look... well I would like the
dropdown list to be just the uppercase values but still allow for the users
to enter lowercase. I would then uppercase all values on saving the
document.

Is this possible?

Jan Agermose