Forum Discussion

beikme's avatar
beikme
Brass Contributor
Nov 21, 2020

key presing

Hi all is there any whey to get excel pres keys whit vba or any other whey    I need something like this    COPY-ALT,TAB-PASTE-F3-ENTER-ALT,TAB,ARROWDOWN   Thanks in advance 
excel
Formulas and Functions
Macros and VBA
Rajesh_Sinha's avatar
Rajesh_Sinha
Steel Contributor
Nov 22, 2020

beikme 

 

You can use the SendKeys method in your VBA code, to simulate keystrokes that you would manually input in the active window.

 

You may refer this page 

beikme's avatar
beikme
Brass Contributor
Nov 22, 2020

Rajesh_Sinha 

 

sorry im not that goods whit vba

is there any chance you can write the vba ?

  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Steel Contributor
    Nov 23, 2020
    Yes I'm well versed with vba,,, but since you are not confident enough then is not good do pick that option. And let me say that vba is the ultimate option for Key Press !!