Calling Excel shortcuts from VBA

M

M G

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/tutorial...4-b0f20bdc955a/parallel-programming-in-c.aspx
 
G

Gary''s Student

Just make the VBA do what the shortcut does.
CNTRL+[
can be implemented by:
Selection.DirectPrecedents.Select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Excel shortcuts from VBA 2
textformatting not available in outlook 2007 0
Disable Cut/Copy/Paste in Excel 2010 0
Calling Embedded Object macros from Excel VBA 0
calling C# DLL from VBA 3
Calling C++ dll in Excel 2000 / 2002 0
Excel 2003 with VBA - "Can't find project or library" 6
problem with "file not found" calling a dll from VBA 6

Top