How to unload the userform with the Enter key...

[Ivan F Moala]

On 2002-04-19 00:05, TsTom wrote:
Is there a userform property to set?
I placed a breakpoint in each event.
Is there a property similiar to "KeyPreview" in VB for VBA userforms?
They are not being fired.
My goal is simple. Close the userform with the Enter key...
Thanks,
Tom

[ This Message was edited by: TsTom on 2002-04-19 00:11 ]

Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

If KeyCode = 13 Then Unload Me

End Sub

[Tom Schreiner]

Thanks Ivan for the quick reply.
That is the code I am using to the letter.
For some reason or another the event will not fire at all?
Could it be the host program?
I am using VBA 6.0. Same as Office 2000.
The host program is WRQ Reflection for Regis Graphics...
Thanks Again...
Tom

[Ivan F Moala]

On 2002-04-19 00:19, TsTom wrote:
Thanks Ivan for the quick reply.
That is the code I am using to the letter.
For some reason or another the event will not fire at all?
Could it be the host program?
I am using VBA 6.0. Same as Office 2000.
The host program is WRQ Reflection for Regis Graphics...
Thanks Again...
Tom

Tom, worked for me in Excel2000.....??

[Tom Schreiner]

Thanks Ivan...
Must be the host program(Not Excel)
Tom