Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    Unanswered: Restrict Cell Entry to Y or N

    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?
    Jerry

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi Jerry,

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •