Need help in combination of Sendkeys for macros

[Mehmud Khan]

Dear Team,

Good day!

Need your assistance in macro;

In macros, I need to use below sendkeys command;

(^ {Tab}) then {RIGHT} {RIGHT}

In simple words, first I want to give keys for "CTRL + TAB" then after holding these together I want to press 2 times RIGHT arrow key commands.


I tried various methods but it won't work.


Please check and help me.

Thanks in advance.

Regards,
-Khan

 

[Logit]

Application.SendKeys ("^{TAB}{RIGHT}{RIGHT}")

 

[Mehmud Khan]

Application.SendKeys ("^{TAB}{RIGHT}{RIGHT}")

Thanks Logit !

But this code is not working.

The codes is working separately I guess...

Application.SendKeys ( ("^{TAB}) ({RIGHT}{RIGHT}) ")

I need similar like above wherein I have to press 2 rights buttons but holding Ctrl+Tab first.


Similer like we are pressing Ctrl+V.


Regards,
Khan

 

[Marc L]

Hello, according to VBA help you should put all the keys in combo with Ctrl key in parenthesis …​

​

 

[Logit]

Mehmud Khan​

All I can say is that the SendKeys works here as requested.

 

[Mehmud Khan]

Hello Logit and Marc!

Good day!

Thanks for your efforts and time...

I have tried multiple attempts but no solution found.

Hence, I have to work to find some alternative solution.

Regards,
Mehmud

 

[p45cal]

In macros, I need to use below sendkeys command;

(^ {Tab}) then {RIGHT} {RIGHT}

In simple words, first I want to give keys for "CTRL + TAB" then after holding these together I want to press 2 times RIGHT arrow key commands.

Would this do the same?:

    Selection.End(xlToRight).Select
    Selection.End(xlToRight).Select

If not, under what circumstances are you wanting to execute these sendkeys? Another application? A dialogue box?
There may be the same thing with quite different code.