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
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