Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a Macro to a FunctionKey... (again, but with correct email address)
Hi
My problem is I would like to run a macro called "five" when I hit the F5 key... (just the key, without Ctrl or Alt key). Excel Does someone would own the code I'm looking for ? Thank you VERY much for your help, I look for a while on the web but don't find anything. Frenchie, doo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a Macro to a FunctionKey... (again, but with correct email address)
Hi Doo
Look in the VBA help for Application.Onkey -- Regards Ron de Bruin http://www.rondebruin.nl "doo" wrote in message ... Hi My problem is I would like to run a macro called "five" when I hit the F5 key... (just the key, without Ctrl or Alt key). Excel Does someone would own the code I'm looking for ? Thank you VERY much for your help, I look for a while on the web but don't find anything. Frenchie, doo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a Macro to a FunctionKey... (again, but with correct email address)
Hello
Thank you for your info, but my problem is that I don't understand at all VBA ... ;-( (where do I write it ? wich syntax ? what is a proc ? etc...) But however thanks a lot for the info, for sure it is what I'm looking for ! Thanxxxs Frenchie doo "Ron de Bruin" a écrit dans le message de ... Hi Doo Look in the VBA help for Application.Onkey -- Regards Ron de Bruin http://www.rondebruin.nl "doo" wrote in message ... Hi My problem is I would like to run a macro called "five" when I hit the F5 key... (just the key, without Ctrl or Alt key). Excel Does someone would own the code I'm looking for ? Thank you VERY much for your help, I look for a while on the web but don't find anything. Frenchie, doo |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a Macro to a FunctionKey... (again, but with correct email address)
Hi doo
You can put a macro like this in a module in the workbook and assign it to a shortcut (F5 in this example) Sub test() MsgBox "Hi" End Sub This in a the Thisworkbook module Private Sub Workbook_Activate() Application.OnKey "{F5}", "test" End Sub Private Sub Workbook_Deactivate() Application.OnKey "{F5}" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "doo" wrote in message ... Hello Thank you for your info, but my problem is that I don't understand at all VBA ... ;-( (where do I write it ? wich syntax ? what is a proc ? etc...) But however thanks a lot for the info, for sure it is what I'm looking for ! Thanxxxs Frenchie doo "Ron de Bruin" a écrit dans le message de ... Hi Doo Look in the VBA help for Application.Onkey -- Regards Ron de Bruin http://www.rondebruin.nl "doo" wrote in message ... Hi My problem is I would like to run a macro called "five" when I hit the F5 key... (just the key, without Ctrl or Alt key). Excel Does someone would own the code I'm looking for ? Thank you VERY much for your help, I look for a while on the web but don't find anything. Frenchie, doo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I put an email address in a macro ? | New Users to Excel | |||
Macro to email to address in cell reference | Excel Discussion (Misc queries) | |||
How can I create a macro for my email address? | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Apply a Macro to a FunctionKey... | Excel Programming |