View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donny Donny is offline
external usenet poster
 
Posts: 11
Default Use Keyboard with KeyDown and KeyUp

I am working on a sheet that has keyboard shortcuts. I want to use
keyboard buttons to control the worksheet. For example, if I press
the "q" key down, I want TextBox1 to appear. When the "q" key is
released (KeyUP), TextBox1 should go away.
TextBox1 can be generated in the code under the KeyDown sub, and
deleted after KeyUp, I just don't know how to catch the keyboard key
actions with KeyDown and KeyUp.

Thanks,
Donny