Can I start a macro using a # key?
 

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

Can I start a macro using a # key?
 

Have you looked at the onkey method in VBA help?

--
Regards,
Tom Ogilvy

"Ftca" wrote in message
...
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

Can I start a macro using a # key?
 

"Tom Ogilvy" wrote in message
...
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



--
Regards,
Tom Ogilvy

"Ftca" wrote in message
...
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