PC Review


Reply
Thread Tools Rate Thread

how can i isert a funtion in F1 or F2? Like F1 put DEP in a space

 
 
=?Utf-8?B?U3RldmVu?=
Guest
Posts: n/a
 
      13th Mar 2007
help me.. can i program keyboard F1, F2 etc with word to put in exel???
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeSBCcm93bg==?=
Guest
Posts: n/a
 
      14th Mar 2007
'/-------------------------------------------------------/
'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
(E-Mail Removed)
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Isert - ("Dash Mark") Steved Microsoft Excel Programming 3 14th Apr 2009 02:08 AM
Need help in VBA Funtion for Autogenerating a Number next to the result of the Funtion FA Microsoft Access Form Coding 1 11th Jan 2006 04:25 PM
funtion please JG Microsoft Excel Discussion 1 17th Oct 2005 10:35 AM
Re: If funtion help RagDyeR Microsoft Excel New Users 2 3rd Jul 2005 07:02 PM
Isert Object - Excel question Salad Microsoft Word New Users 1 27th Oct 2004 02:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:52 PM.