Simulating Key Presses in Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aswini.ks@gmail.com - 22 Mar 2006 06:48 GMT

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.

Reply to this Message

ward376 - 22 Mar 2006 07:43 GMT

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.

Reply to this Message

Ivan F Moala - 22 Mar 2006 07:59 GMT

If it is the About dialog you want to invoke then

Code
-------------------

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

-------------------

--
Ivan F Moal

Reply to this Message

ward376 - 22 Mar 2006 10:46 GMT

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

Reply to this Message