Simulating Key Presses in Macros

[email protected] · 03-22-2006, 01:55 AM

Hi,

How do I simulate pressing the keys using a macro in Excel. For
example, if I want to simulate pressing the keys Alt+H+A, what should I
do in the macro?

Thanks.

ward376 · 03-22-2006, 02:45 AM

Try something like:

Private Sub CommandButton1_Click()
Application.SendKeys ("%ha")
End Sub

If you execute from the vb editor, you get the About box for Visual
Basic, but this brings up about for Excel.

**Ivan F Moala** · 03-22-2006, 02:59 AM

If it is the About dialog you want to invoke then

Sub About()
    Application.CommandBars.FindControl(ID:=927).Execute
End Sub

ward376 · 03-22-2006, 05:50 AM

Ivan! Sweet! Where do you look for the ID numbers?

Simulating Key Presses in Macros

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Simulating Key Presses in Macros

Re: Simulating Key Presses in Macros

Re: Simulating Key Presses in Macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions