This is what i have, i got it from this forum. I want to make it so ctrl and the up arrow key must be pressed together to trigger it. so i know that ^ is the code for ctrl, and ive been trying ^UP, but then it says something about onkey and yeah idk. Any help greatly appreciated. Thanks!
Sub AA()
Application.OnKey "{UP}", "Increment"
End Sub
Sub Increment()
On Error GoTo Last
ActiveCell.Value = ActiveCell.Value + 1
Last:
End Sub
Hi,
To trap the keystroke, you'll need to put some code in the workbook module:
Then, put the other code in a standard module:
Please Login or Register to view this content.
Finally save, close and then reopen your workbook and it should work fine.Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks for the fast response. I'm a big beginner. Sorry but what is the difference between workbook module and standard module? Confused on how to implement this.
OK,
Once you have excel open, hit ALT & F11 to open the VBA editor.
If you don't have the project explorer window open in the top left, go to view > project explorer
In the project explorer window doubleclick "ThisWorkbook" and in the blank window that opens paste the first section of code.
Next go to Insert > Module and paste the next set of code in the window that appears.
Close the VBA editor.
Finally save, close and then reopen your workbook and it should work fine.
sweep, you are the man. thank you!! works like a charm. this is visual basic stuff is a lot of fun.
You're welcome - glad you're enjoying it!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks