Thread: Access Key
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg B[_15_] Greg B[_15_] is offline
external usenet poster
 
Posts: 7
Default Access Key

I asked last week about access keys and I need to ask a bit more.

Sub SetupF2()
Application.OnKey "{F2}", "OpenForm"
End Sub

Sub OpenForm()
UserForm1.Show
End Sub


This was the code I was given but it does not seem to work with userform. I
placed the code in the userform activate macro, and when I press f2 it does
not do a thing.

Is it possible to use the function keys from a userform?

Thanks
Greg