Userforms

[moontho]

Hi there.

2 quick questions that i've been trying to workout today, but to no avail.

Firstly, what is the difference between using the show method for a userform, compared to the load method....

and secondly, is there any benefit in writing the code for a userform, or writing it in a module and calling it from there.

Many thanks

Thom

 

[FXP]

(1) If you hide the form and use Show, it becomes visible and if not loaded, is loaded.

(2) keeping the code with the form has the benefit of encapsulation. The form and associated code are together, self-contained.

I'm sure others will expand on all this.