Excel Field Format

Posted by Barrie Bowdler on September 24, 2001 4:26 AM

I want to type the letter "Y" or "N" into a cell and that cell to display the words "Yes" for 'Y' and "No" for 'N' - how can I achieve this
Would appreciate some help.

Posted by Raich on September 24, 2001 5:23 AM

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then
If Target.Value = "Y" Then Target.Value = "Yes"
If Target.Value = "N" Then Target.Value = "No"
End If
End Sub