Commands after userform unload

Hi again,

(I've never seen such a code construction)

Check out "Professional Excel Development", by Bovey, Wallentin, Bullen & Green


Thanks for your last post - now that the picture is a bit clearer, see if the attached workbook does what you need.


Also,

- both forms are loaded and you hide the form when it is needed.

No, this is not the case - once the first UserForm is displayed, control is transferred from the calling routine to the code in the first UserForm CodeModule. Control is returned to the calling routine only after the first UserForm has been hidden (by clicking on the "Next" button). It is only at this stage that the second UserForm is loaded and displayed.


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

Regards,

Greg M

Originally Posted by Maverick71

Hello,
...
It works. ....
What do you think about this?

That's the key.

Hi again,

Thanks for posting your latest version.

Although your following code "works":

Please Login or Register  to view this content.

you are actually using the UserForm templates themselves rather than new instances of those UserForms. Good practice would create specific instances of the UserForms for use by your routine, for example:

Please Login or Register  to view this content.

Also, there's no need to name the "OK" Property of the second UserForm as "OK2" - the variables & properties used by each UserForm remain separated from each other, and when used in your calling routine each property will be prefixed by the variable which represents the specific UserForm (e.g. frm_2.OK), so there's no danger of the property values being "mixed up" by the calling routine.


Hope this helps - feel free to ask if there's anything you want further information on.

Regards,

Greg M



P. S. Regarding the previous post, there is a BIG difference between something that "works", and something that is well-designed!