Thread: Hotkeys
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg B[_17_] Greg B[_17_] is offline
external usenet poster
 
Posts: 9
Default Hotkeys

Hello and Good morning or evening,

I am wondering about something I have tried a piece of code I found on the
web regarding hotkeys. It will work perfectly in the main excel sheet but I
am hoping to have the capabilities when it has a userform showing. This
code has been put in the open code of the worksheet where would I put it to
be used in the userform?
If this cant happen I am hoping to be able to press 1 button on the keyboard
to shutdown the userform("Sales") and then execute the code for the next
sale.

Application.OnKey "{F3}", "endsale"

Thanks In Advance

Greg B