auto insert text

[John_G]

How do I format cells so that when I enter the first letter of a word, it automatically enters that word. For example, if I want "yes" or "no" in the cell, once I type "y" it will come up "yes"; and once I type "n" it will come up "no".

Thanks.

John G.

[VBA Noob]

You could take a look at Tools > autocorrect options for a non VBA way otherwise it would be an event macro

Example code below. Right click sheet tab > select view code > paste in the below. Change A1:A100 to your range

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
    Select Case UCase(Target)
        Case "Y": Target.Value = "Yes"
        Case "N": Target.Value = "No"
    End Select
End If
        
End Sub

VBA Noob