Excel - Auto-move to next cell after input

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
Syrup
Posts: 27
Joined: 22 Aug 2018, 08:38

Excel - Auto-move to next cell after input

Post by Syrup » 29 Nov 2021, 15:24

Hello.

My goal is to have a script that will automatically move to the next cell in an excel spreadsheet after inputting any key in a specific cell range. So for most of the spreadsheet I don't want the ahk script to do anything, but for a limited range of cells (about a dozen) I'd like a script that, after inputting any key (for example the letter "k") will automatically move to the next cell.

The final bit is easy enough, just need to "Send, {Right}" after a key input. The problem is, I have no clue if there is a way to "activate" an ahk script only when I'm inputting values in certain excel cells (for example, the B11 through B25 cells).

So...help? lol

User avatar
flyingDman
Posts: 2791
Joined: 29 Sep 2013, 19:01

Re: Excel - Auto-move to next cell after input

Post by flyingDman » 29 Nov 2021, 15:32

Will the input in these cells be limited to only one letter or digit? What if the cell is not empty?
14.3 & 1.3.7

Syrup
Posts: 27
Joined: 22 Aug 2018, 08:38

Re: Excel - Auto-move to next cell after input

Post by Syrup » 30 Nov 2021, 00:09

For sure only one letter or digit. If cell is not empty it can (needs-to) be overwritten (I can wipe it clean manually if needed, but ideally it would just overwrite previous content).

Post Reply

Return to “Ask for Help (v1)”