Turning off autocomplete for one cell only

[Brad]

I would like to turn off autocomplete for one cell only.

I understand that I can do this by having a blank line above and below the
cell and a blank column to the right and left of the cell. Is there any
another way??

 

[Gary''s Student]

This is for cell B9, adjust to suite:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("B9"), Target) Is Nothing Then
Application.EnableAutoComplete = True
Else
Application.EnableAutoComplete = False
End If
End Sub

This is worksheet event code and goes in the worksheet code area, not a
standard module.

 

[Brad]

Thank you!

That was easy!

This is for cell B9, adjust to suite:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("B9"), Target) Is Nothing Then
Application.EnableAutoComplete = True
Else
Application.EnableAutoComplete = False
End If
End Sub

This is worksheet event code and goes in the worksheet code area, not a
standard module.