Can I start a macro using a # key?

[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]

Have you looked at the onkey method in VBA help?

 

[Ftca]

Have you looked at the onkey method in VBA help?

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