How can i set-up home key go to a particular cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set-up my Home key on keyboard to go to a particular cell and not
the begining.
 
Doubt that that is a good idea but, here is how you can do that.

Reference
http://msdn.microsoft.com/library/d...en-us/vbaxl11/html/xlmthOnKey1_HV05203370.asp

Sub botchup_home()
Application.OnKey "{HOME}", "Alternative_Home"
end sub

sub unbotch_home()
application.onkey "{HOME}", ""
end sub

Sub alternative_Home()
range("F14").activate
end sub

Also some additional information in
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Please use your first and last name in newsgroups at least in these newsgroups it is a lot more
friendly and shows an interest and desire to participate in helping others not necessarily
in this newsgroup but anywhere, as opposed to just using newsgroups to get an answer.. It's a lot
more friendly. And it can be really nice to recognize a name from some other area when someone
asks for help in an area you are more familiar with. Of course you usually need more than just
a first and last name to identify yourself a little more especially cross disciplines.
 
Back
Top