Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default how can i isert a funtion in F1 or F2? Like F1 put DEP in a space

help me.. can i program keyboard F1, F2 etc with word to put in exel???
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default how can i isert a funtion in F1 or F2? Like F1 put DEP in a space

'/-------------------------------------------------------/
'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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Space removal - a first name,space last name Tech Express Excel Discussion (Misc queries) 4 February 9th 09 08:24 PM
formula that will go up one space if no value in specified space skammi Excel Worksheet Functions 1 November 16th 05 03:28 PM
Paper Space / Model Space ? Coolboy55 Excel Discussion (Misc queries) 0 September 1st 05 08:58 PM
If funtion help fetzer New Users to Excel 5 July 3rd 05 07:02 PM
IF funtion viddom Excel Discussion (Misc queries) 2 June 30th 05 02:53 PM


All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"