key presing

Question

Hi allis there any whey to get excel pres keys whit vba or any other whey&nbsp;&nbsp;I need something like this&nbsp;&nbsp;COPY-ALT,TAB-PASTE-F3-ENTER-ALT,TAB,ARROWDOWN&nbsp;Thanks in advance&nbsp;

rajesh_sinha · Answer

beikme&nbsp;&nbsp;You can use the SendKeys method in your VBA code, to simulate keystrokes that you would manually input in the active window.&nbsp;You may refer this page&nbsp;

beikme · Answer

Rajesh_Sinha&nbsp;&nbsp;sorry im not that goods whit vbais there any chance you can write the vba ?

eva vogel · Answer

beikmeDon´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:&nbsp;Assign Keyboard Shortcuts to Macros Using Excel VBA - YouTubeIf 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.&nbsp;Best regards,Eva.&nbsp;

beikme · Answer

Eva Vogel&nbsp;&nbsp;HiThe only reason i'm asking in the forum is that i try it&nbsp; already&nbsp;red about&nbsp; it and research it and still could not do it&nbsp;Than You&nbsp;

eva vogel · Answer

beikme&nbsp;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: ... "&nbsp;&nbsp;Give us more food, then we can help you 🙂&nbsp;Best regards,Eva.

Forum Discussion

key presing

6 Replies