key presing

%3CLINGO-SUB%20id%3D%22lingo-sub-1921297%22%20slang%3D%22en-US%22%3Ekey%20presing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3Eis%20there%20any%20whey%20to%20get%20excel%20pres%20keys%20whit%20vba%20or%20any%20other%20whey%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20something%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECOPY-ALT%2CTAB-PASTE-F3-ENTER-ALT%2CTAB%2CARROWDOWN%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921338%22%20slang%3D%22en-US%22%3ERe%3A%20key%20presing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921338%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20can%20use%20the%20SendKeys%20method%20in%20your%20VBA%20code%2C%20to%20simulate%20keystrokes%20that%20you%20would%20manually%20input%20in%20the%20active%20window.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.application.sendkeys%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EYou%20may%20refer%20this%20page%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921340%22%20slang%3D%22en-US%22%3ERe%3A%20key%20presing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esorry%20im%20not%20that%20goods%20whit%20vba%3C%2FP%3E%3CP%3Eis%20there%20any%20chance%20you%20can%20write%20the%20vba%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921341%22%20slang%3D%22de-DE%22%3ESubject%3A%20key%20presing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921341%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%3C%2FP%3E%3CP%3EDon't%20ask%20without%20efford%20for%20your%20own%20benefits.%20When%20you%20are%20showing%20others%20here%2C%20that%20you%20are%20trying%20to%20get%20your%20task%20done%20and%20you%20are%20struggling%20with%20it%2C%20someone%20is%20also%20willing%20to%20help%20you.%20It's%20a%20common%20thing%20to%20learn%20someting%20new.%20For%20instance%20you%20can%20explore%20the%20various%20videos%20on%20VBA%20Recording%20methods%20on%20YouTube%20to%20record%20your%20steps%20and%20save%20it%20to%20your%20workbook%2C%20like%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqzITcWEFYW0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAssign%20Keyboard%20Shortcuts%20to%20Macros%20Using%20Excel%20VBA%20-%20YouTube%3C%2FA%3E%3C%2FP%3E%3CP%3EIf%20your%20workbook%20is%20stored%20online%20like%20in%20OneDrive%20or%20SharePoint%2C%20i%20suggest%20you%20learn%20the%20new%20Office%20Scripts%20Editor%20within%20your%20Excel%20Web%20App%2C%20when%20your%20Workbook%20is%20opened%20online%20(office%20365%20in%20your%20Browser).%3C%2FP%3E%3CP%3EHave%20a%20nice%20sunday.%20And%20with%20respect%3A%20start%20with%20YOUR%20Task%20today%2C%20first.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EEva.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1922816%22%20slang%3D%22en-US%22%3ERe%3A%20key%20presing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1922816%22%20slang%3D%22en-US%22%3EYes%20I'm%20well%20versed%20with%20vba%2C%2C%2C%20but%20since%20you%20are%20not%20confident%20enough%20then%20is%20not%20good%20do%20pick%20that%20option.%20And%20let%20me%20say%20that%20vba%20is%20the%20ultimate%20option%20for%20Key%20Press%20!!%3C%2FLINGO-BODY%3E
Contributor

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 

6 Replies

@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 

@Rajesh-S 

 

sorry im not that goods whit vba

is there any chance you can write the vba ?

@beikme

Don´t ask without efford for your own benefits. When you are showing others here, that you are trying to get your task done and you are struggling with it, someone is also willing to help you. It´s a common thing to learn someting new. For instance you can explore the various videos on VBA Recording methods on YouTube to record your steps and save it to your workbook, like this: Assign Keyboard Shortcuts to Macros Using Excel VBA - YouTube

If your workbook is stored online like in OneDrive or SharePoint, i suggest you learn the new Office Scripts Editor within your Excel Web App, when your Workbook is opened online (office 365 in your Browser).

Have a nice sunday. And with respect: start with YOUR Task today, first.

 

Best regards,

Eva.

 

@Eva Vogel 

 

Hi

The only reason i'm asking in the forum is that i try it  already 

red about  it and research it and still could not do it 

Than You 

@beikme You can describe what you got and what you are willing to to with your Table or Workbook or Worksheet. Your shortcut list is not enough. You can instead write down, what you have like

"1) I have this list with these columns and these column types: ...

2) I want to do this: ..." .... etc.

3) Finally the stuff should look as the next screenshot / the following: ... " 

 

Give us more food, then we can help you

 

Best regards,

Eva.

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 !!