Hi,
I would like to increase/decrease by 1 the content of a cell by using the up and down arrow keys.
Does anyone knows an easy way, possibly not using a macro, to do that?
thanks for any help
pagheca
Hi,
I would like to increase/decrease by 1 the content of a cell by using the up and down arrow keys.
Does anyone knows an easy way, possibly not using a macro, to do that?
thanks for any help
pagheca
Good evening pagheca
...and welcome to the forum!!
Nope - not without using a macro, but it's really easy - read on.Originally Posted by pagheca
Open your workbook, and press Alt + F11, and then go to Insert > Module.
An empty window will open. Copy the code below into the window. Read the code - there's nothing scary to it, it does exactly what yu requested :
Now go to File > Close and Return to Microsoft Excel.![]()
Please Login or Register to view this content.
Now go to Tools > Macro > Macros, and select "test" from the box and click Run. Nothing will appear to happen, except a 0 will appear in cell A1. now use the up/down buttons to change its value.
Your first macro!![]()
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
WOW! It works great. I'm really impressed by the moderator and by the module as well!
cheers
pagheca
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks