G Greg B Jul 26, 2008 #1 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
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
B Bob Phillips Jul 26, 2008 #2 Application.OnKey "{F10}", "myProc" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Application.OnKey "{F10}", "myProc" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
G Greg B Jul 26, 2008 #3 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
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
B Bob Phillips Jul 26, 2008 #4 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)
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)
G Greg B Jul 26, 2008 #5 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
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
B Bob Phillips Jul 27, 2008 #6 Don't understand what you mean exactly. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Don't understand what you mean exactly. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
