ENTER keys to execute code to add menu

[Mark Warner]

I looked through the previous topics but didn't see what I need.

I want that when a person hits the enter key in cell C2 that it executes
code to bring up a customized menu. Also WHERE in the code does this go, a
module, or in the SHEET1 objects area?

I have tried this code:

Private_Sub SetKey()
Application.OnKey "~", "supmenu"
Application.OnKey "{ENTER}", "supmenu"
End Sub


Thanks.

 

[stevebriz]

I looked through the previous topics but didn't see what I need.

I want that when a person hits the enter key in cell C2 that it executes
code to bring up a customized menu. Also WHERE in the code does this go, a
module, or in the SHEET1 objects area?

I have tried this code:

Private_Sub SetKey()
Application.OnKey "~", "supmenu"
Application.OnKey "{ENTER}", "supmenu"
End Sub


Thanks.

Is another option to use the worksheet_change and for that cell?

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$C$2" Then
' do stuff here'
End If
End Sub