Emulate "Ctrl+[" via VBA

[Darker0ne]

Hello!

I'm trying to create a macro, that I can then place in the "Quick Access Toolbar" that does the same as "Ctrl+[".
My Excel is Portuguese, and I can't find a way to make that shortcut working.
So, I thought that I could use the SendKeys VBA command.
But doesn't seem to work either.

I'm writting:

SendKeys "^{]}"

But it just prints the "[", instead of toggling anything.

Can someone help me with this please?

Thank you!

 

[Darker0ne]

Hello,

I just tested the code, works good except for the part of going for other sheets...

Do you know any work around this part?

Thank you for your help so far, rest of the code works perfectly !

 

[Darker0ne]

Ok I found something similar.
Is an option caled "Allow Editing direclt in cells".
Now when I double click a cell, it takes me to the cell, even if it is on another sheet.
Very un-intuitive...

Anyway thank you so much for your help!