Can I start a macro using a # key?

  • Thread starter Thread starter Ftca
  • Start date Start date
F

Ftca

Hi all
can anyone help me with starting a macro called "gsw"
by using the # or | or ~ key?
The reason being I am trying to activate this macro
by barcode scan and I cannot print a barcode using
ctrl + X

TIA
 
Tom Ogilvy said:
Have you looked at the onkey method in VBA help?
Click to expand...


As usual Tom
you've steered me in the right direction

a quick google groups search and............

FWIW
I used this method
from vb (shift F11)
insert
module
pasted in

Sub keytrap()
Application.OnKey "{TAB}", "gsw"
End Sub

(seemed your name was in this post/thread too)

now a simple step to subst TAB with one of my prefered choices
and "Bob's yer Uncle!"

Thanks Tom
 
Back
Top