Press ECS to close userform

[AmirSoft]

Hi Experts!

I am developing a userform with multiple controls mostly Text Boxes and Combo Boxes etc.
I can set KeyAscii or keycode function for each control to unload userform.
But
It is too lengthy and difficult to set Ascii or keycode function for every control.

I want
Is there any option to set this function shortly?

I shall be very thankful for help.

Thanks
Amir

[MarvinP]

Hi Amir,

Instead of setting up shortcut keystrokes to get to all your controls on a userform, why don't you use the TAB key to move from each to the next. You can set each control's TAB ORDER and then only need to use the TAB key to get to each.

I don't believe you can program the ESC key on a userform. I believe the ESC key is used as an escape from other problems.

[grimes0332]

As a userform cannot accept keystrokes, the easiest way to do this would be to add a CommandButton and set it's Cancel property to True.

[Greg M]

Hi there,

See if the attached workbook does what you need - pressing the ESC key will hide the UserForm.

It uses the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

And the following code in the VBA CodeModule of the UserForm:

Please Login or Register  to view this content.

If appropriate, you can make the Close button visible by removing the statements which change its dimensions.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[AmirSoft]

Thanks Greg M
Your first code shows an error.

[Greg M]

Hi again,

I downloaded the workbook posted in this thread, and it works correctly on my installation.

What sort of error are you encountering?

Regards,

Greg M

[AmirSoft]

I want to open that userform from another userform. While that process it shows an error.

That thing I want to achieve.

[AmirSoft]

I want to open that userform from another userform. While that process it shows an error.

That thing I want to achieve.

[Greg M]

Hi again,

I'm sorry, but:

I want to open that userform from another userform. While that process it shows an error.

really doesn't describe the problem in any meaningful way

Regards,

Greg M