Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Excel Macro, need to use key combination in macro

In Excel I can access a function by pressing the Alt key, then the S key, then the R key and then the D key

I want to put this in a macro format where I run it and it would send these keys in Excel.

I have been trying the Application.sendkey without any luck.
0
wilpitz
Asked:
wilpitz
  • 4
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Are you trying to send Alt+SRD ?
0
 
wilpitzAuthor Commented:
No it needs to be each single key
0
 
Martin LissRetired ProgrammerCommented:
So Alt, the S then R then D? or Alt+S, Alt+R, Alt+D?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Martin LissRetired ProgrammerCommented:
Just in case, to send Alt+S do

Application.SendKeys("%S")
0
 
wilpitzAuthor Commented:
Yep got it to work!

Application.SendKeys ("%S")
Application.SendKeys ("R")
Application.SendKeys ("D")
0
 
Martin LissRetired ProgrammerCommented:
I'm glad I was able to help.

Marty - MVP 2009 to 2012
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now