By default the DV list is restricted to what is in the list.

When you set up the list, set the Case in the cells you use for the list.

If you are using a comma-delimited list type the list in the Case you want.

i.e. QWERTY,Asdfgh,zxcvbnm


Gord Dibben MS Excel MVP


On Wed, 11 Apr 2007 12:24:02 -0700, QLCKristen
wrote:

Is there a way to restrict some list validation values to be in all caps
while others in the same validation value list are either mixed or lower case?