I have a checkbook that I've maintained in Excel for a while now and I have it working pretty much the way I want it to work. The way I currently reconcile transactions is to filter so that only unreconciled transactions are visible and then I go down the transactions and DOUBLE CLICK the cell in the appropriate column for each transaction to toggle between R and "". Of course, that process is done using a Private Sub Worksheet_BeforeDoubleClick function.
I've been pondering whether there is an easier way to accomplish this. I recall when I use to use Quicken, I could just go down the list of unreconciled transactions and press the ENTER key to show them as reconciled, or the ARROW KEY to skip over a transaction. I like that but I'm not sure the ENTER key can be captured in a keypress event. I haven't been able to find a way to do it at any rate. Can anyone think of an way to achieve the desired effect that is easier than Worksheet_BeforeDoubleClick?