User FAQs

If you have a question, please send it to us.

1) Is there a way to close a userform by pressing the ESC key ?
Yes. You need to change the "Cancel" property for the cancel button to the "True".
Make sure that the Cancel property for all the other buttons is set to False.

2) What is the difference between Hiding a userform and Unloading a userform ?
There is a big difference between Hiding a userform and Unloading it.
If you Hide a userform, it is not visible but still remains in memory.
Hiding a userform can be useful when it takes a while to initialise all the controls and the userform will be displayed more than once.
In this situation it will be quicker to hide and then show the userform, rather than unloading and loading.

3) It is possible to display a userform in an exact position of the screen ?
Yes. You can use the Userforms Left and Top properties. In order for this to be effective you must set the StartUpPosition property to 0.