Hello all,
I don't know whether the subject line makes sense, but I'll try to specify my problem here again:
As I want to learn portuguese and created my own excel to test my vocabulary, I sometimes need to include special characters like ã or ç. I don't have those on my german keyboard, so I tried to programm hot-keys for that, e.g. by pressing ctrl+a it should give me the ã.
I found the command Application.OnKey "^a", "a_til" which I wrote in the "ThisWorkbook sheet-object" which works fine. When I select a cell and press ctrl+a it gives me the ã at the end of the word which I already have typed.
What I now have to do is press enter, go up to the cell and press F2 to be able to continue writing the last part of the word.
Do you know whether there is a solution to this, so that I can immediately continue writing the word without the detour (enter/up/F2)?
Many thanks and have a nice weekend,
Sebastian
I don't know whether the subject line makes sense, but I'll try to specify my problem here again:
As I want to learn portuguese and created my own excel to test my vocabulary, I sometimes need to include special characters like ã or ç. I don't have those on my german keyboard, so I tried to programm hot-keys for that, e.g. by pressing ctrl+a it should give me the ã.
I found the command Application.OnKey "^a", "a_til" which I wrote in the "ThisWorkbook sheet-object" which works fine. When I select a cell and press ctrl+a it gives me the ã at the end of the word which I already have typed.
What I now have to do is press enter, go up to the cell and press F2 to be able to continue writing the last part of the word.
Do you know whether there is a solution to this, so that I can immediately continue writing the word without the detour (enter/up/F2)?
Many thanks and have a nice weekend,
Sebastian