PDA

View Full Version : Solved: Toolbar/CommandButton - OnAction



Philcjr
12-29-2008, 08:07 PM
For "OnAction", with CommandButtons do you have to use a macro name?

I would like to be able to add a button for going to Top of Sheet in Col A... I was thinking something along the lines of OnKey "^{HOME}"

I would like to be able to add a button for going to LastRow of Sheet in Col A... I was thinking something along the lines of OnKey "^+{DOWN}"

Creating seperate macros I can do, I was just wondering if the "OnAction" could be used differently to simulate key strokes

Any thoughts?
Phil

Bob Phillips
12-30-2008, 03:19 AM
It has to be a macro, so just create a macro to do those things.

Philcjr
12-30-2008, 06:11 AM
Thanks XLD