View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
musicgold via OfficeKB.com musicgold via OfficeKB.com is offline
external usenet poster
 
Posts: 7
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.

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