musicgold
05-18-2010, 03:20 PM
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.
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.