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

<pre/>
Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 13 Then Unload Me
End Sub</pre>

 

[Legacy 98055]

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.....??

 

[Legacy 98055]

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