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

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

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

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

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

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