How do I run a macro in Excel when the enter key is pressed on a specific cell

[Timjohnson]

I'm currently trying to create a tool that will call/run another macro/sub when the enter key is pressed on cell B4.


Cell B4 will be the search field. Whenever someone types something in this field and hits enter on their keyboard I want another macro called "searchcontains" to run


I've tried using this code but I'm not sure how to specifically define the B3 cell:


Application.OnKey "~", "searchcontains"

 

[lrobbo314]

How about this?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B4")) Is Nothing Then
    searchcontains
End If
End Sub