View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Warner[_2_] Mark Warner[_2_] is offline
external usenet poster
 
Posts: 4
Default ENTER keys to execute code to add menu

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.