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!

 

[RoryA]

What does that shortcut do on a Portuguese system?

 

[Darker0ne]

Hello,

Well, I can't press "Ctrl + [" directly either, because my keyboard is also Portuguese.
So, to do a "[" on a Portuguese keyboard, you have to press "Alt+8" which reflects into a "[".
When I go to Formulas > Trace Precedents and mouse over it, the tooltip seems correct...
"Show arrows that indicate which cells affext the value of the currecntly selected cell. Use Ctrl+[ to navigate to precedents of the selected cell."
I click there once, and the arrows appear. But I wasn't able to make the "Ctrl+[" to work yet, doesn't seem to work if i keep clicked that button, seems I have to shortcut it via keyboard. So, since i can't click it, I thought about emulating the clicks, but seems I'm doing something wrong...

Thank you!

 

[RoryA]

Instead of using sendkeys, try using:

    On Error Resume Next
    Selection.ShowPrecedents

 

[Darker0ne]

Hello,

Well, that emulates a click on Formulas > Trace Precedents.
But I want to "navigate" inside that formula, as if i pressed "Ctrl+[" or "Ctrl+]".

That's what I can't do :|

 

[Fluff]

How about

'  ctrl[
   Selection.DirectPrecedents.Select
'  ctrl]
   Selection.DirectDependents.Select

 

[Darker0ne]

Hello!

Well, it works, it just selects all the cells.
What I want was simulate the behaviour of "Ctrl+[" that goes part by part of the formula.
Also, with the code above, it only works on the same sheet, if i remember correctly, "Ctrl+[" works on the workbook.

But thank you!
It partially works already!

 

[Fluff]

I simply recorded a macro of me using Ctrl [ & that is what I got.
If that's not what you're after, unfortunately I can't help any further.

 

[Darker0ne]

Ok.
Is possible for you to check while having cells in multiple sheets?
Does it jump from sheet to sheet?
How can I make the macro stop without giving me any error? Like a... " iferror, then stop macro ".

Thank you for the help!

 

[Fluff]

to stop the error wrap the code in an error handler like

On Error Resume Next
Selection.DirectPrecedents.Select
On Error GoTo 0

& yes it did take me to other sheets