In former Excel releases it was possible to write macro's by hand, f.i.:
If I wanted Excel to wait until I wrote a date followed by an <ENTER> then Excel went 1 cell to the right, wrote down Payed, waited until I wrote down what had to be paid (1 bottle of whiskey) followed by an <ENTER> then went 2 cells to the right, waited until I wrote down the amount (15,75) followed by an <ENTER> then went 1 cell down and then 3 cells to the left (the cursor is on cell A4 now enabling me to do the following item)
A B C D
1 date: description: amount:
2
3 Okt 14 Payed 1 bottle of whiskey €15,75
4
5
6
7
I wrote the following macro for that:
{?}{R}Payed{?}~{R 2}{?}{D}{L 3}
I could start the macro with <CONTROL> + B for instance.
Now, in the new releases of Excel these macro's don't work anymore.
How can I get to the same result now? (a macrorecording does not help because it allways wants to start in the same cell (from where it was recorded))
Can anyone help me with this?
Sandert
If I wanted Excel to wait until I wrote a date followed by an <ENTER> then Excel went 1 cell to the right, wrote down Payed, waited until I wrote down what had to be paid (1 bottle of whiskey) followed by an <ENTER> then went 2 cells to the right, waited until I wrote down the amount (15,75) followed by an <ENTER> then went 1 cell down and then 3 cells to the left (the cursor is on cell A4 now enabling me to do the following item)
A B C D
1 date: description: amount:
2
3 Okt 14 Payed 1 bottle of whiskey €15,75
4
5
6
7
I wrote the following macro for that:
{?}{R}Payed{?}~{R 2}{?}{D}{L 3}
I could start the macro with <CONTROL> + B for instance.
Now, in the new releases of Excel these macro's don't work anymore.
How can I get to the same result now? (a macrorecording does not help because it allways wants to start in the same cell (from where it was recorded))
Can anyone help me with this?
Sandert