LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
M G M G is offline
external usenet poster
 
Posts: 2
Default Calling Excel shortcuts from VBA

Hi,

I am trying to automate the following two excel shortcuts using VBA. I know I can use commandbar and commandcontrol to call excel menus but I can not find the submenus these shortcuts belong to.

1. Ctrl + [ -- cursor goes to the precedent cell
2. F5 + Enter -- cursor goes to the original cell


Also, is it possible to call an excel shortcut from VBA? I know that one can call a worksheet function from VBA (For example, Application.WorksheetFunction.Fact(5) ). But is there way to call a shortcut, say Ctrl + C from VBA?

Thanks,

MG.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorials...ming-in-c.aspx
 
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
Shortcuts Excel 2007 LTJ Excel Discussion (Misc queries) 0 July 4th 07 01:18 PM
How to remember shortcuts in excel? Mr.Cools New Users to Excel 6 August 8th 06 11:49 PM
85 Keyboard Shortcuts for Excel Doug Kanter Excel Discussion (Misc queries) 1 April 28th 06 02:35 PM
shortcuts in Excel SamelaD Excel Worksheet Functions 1 October 9th 05 05:58 PM
shortcuts to excel files. nitm Excel Programming 11 February 14th 05 05:37 PM


All times are GMT +1. The time now is 03:00 PM.

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"