Function Access Keys
Don't understand what you mean exactly.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Greg B" wrote in message
...
Thanks I got it working from the spreadsheet code, Is it possible to get
it working from the userform called main.
Sorry to be annoying.
Greg B
"Bob Phillips" wrote in message
...
Works for me
Sub SetupF2()
Application.OnKey "{F2}", "OpenForm"
End Sub
Sub OpenForm()
UserForm1.Show
End Sub
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Greg B" wrote in message
...
Sorry just to go on with this a bit, I have tried what you wrote and
nothing is happening.
What I am trying to do is have another userform open when the f2 key is
pressed.
the userform title is "sales"
Thanks again
"Bob Phillips" wrote in message
...
Application.OnKey "{F10}", "myProc"
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Greg B" wrote in message
...
I am wondering if it possible to add use of the f keys during excel
vba? if so how or where do I look this up?
Thanks
Greg B
|