Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
help me.. can i program keyboard F1, F2 etc with word to put in exel???
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
'/-------------------------------------------------------/
'Purpose of Macro: 'assign new Action to the Function F2 key 'not case sensitive - F2 Function key sub AssignKey_F2( ) Application.OnKey "{f2}", "Example_F2" end sub '/-------------------------------------------------------/ 'Purpose of Macro: 'performs desired action for F2 key sub Example_F2( ) activecell.value = "DEP" end sub '/-------------------------------------------------------/ 'Purpose of Macro: 'set F2 key back to default sub AssignKeysBack2Default( ) Application.OnKey "{f2}" end sub '/-------------------------------------------------------/ -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Steven" wrote: help me.. can i program keyboard F1, F2 etc with word to put in exel??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |