Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Access Keys
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Access Keys
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Access Keys
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Access Keys
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Access Keys
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Keys Not Working | Excel Discussion (Misc queries) | |||
Keys to access the tabs and commands on the screen | New Users to Excel | |||
Excel 2003 Access Keys In 2007 | Excel Discussion (Misc queries) | |||
Using function keys in macros | Excel Programming | |||
Function Keys in Excel | Excel Discussion (Misc queries) |