VBA OnKey not working woth form

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
VBA OnKey not working woth form

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 29th, 2010, 07:21 PM

brettw

Registered User

Join Date: Jan 2010

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

VBA OnKey not working woth form

When i make a module with the onkey code in it, it works.
But it doesn't work with a userform?

Code:

Sub main()
Application.OnKey "a", "test"
End Sub
Sub test()
msgbox "ace"
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code not working in 2007	blue9244	Excel VBA	4	August 20th, 2009 09:11 AM
Excel formula not working in vba	yogeshyl	Excel VBA	2	December 12th, 2007 02:27 AM
Excel formula not working in VBA	yogeshyl	Excel VBA	2	July 19th, 2007 03:57 AM
Excel vba query not working, pls help me.	kavisundar	SQL Language	0	May 16th, 2007 10:14 AM
Chapter 8 VBA 2000: frmCriteria not working.	Chris1	BOOK: Beginning Access VBA	0	September 7th, 2004 09:31 AM