With an Excel 2003 data validation list of "Y,N", can I use the data validation function to accept lowercase 'y' or 'n' but change lowercase letters to uppercase if needed? Or should I accept all 4 values and use VBA with the sheet's Change event to uppercase the values?
The latter choice of the two. I normally only allow upper case and in the data validation message box, I explain that entries must be upper case. The users catch on and it saves me having to use VBA for it.