Prev: Calling Excel shortcuts from VBA
Next: Unlink chart from sheet
From: musicgold via OfficeKB.com on 20 May 2010 08:38
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.

--
Message posted via http://www.officekb.com

 | 
Pages: 1
Prev: Calling Excel shortcuts from VBA
Next: Unlink chart from sheet