Advice on passing userform parameters to a vba class module

[techno_gronk]

Hi folks

Is anyone able to advise me or point me in the right direction on "the correct" way to pass parameters from user-form selections into a vba class module.

My intention is to perform calculations based on the userform parameters selected.

I am using using a class module in order to utilize the code using similar inputs for;
1. an interactive single calculation on a user-form
2. and batch calculations on another user-form.

Hope this makes sense. Thanks in advance.

[Greg M]

Hi there,

If you want to maximise the encapsulation of your UserForm and Class modules, I suggest the following approach:

Within an "overall" module/routine:

Create an instance of your UserForm and display (.Show) it,

Allow the User to enter data in the UserForm and then hide (.Hide) the UserForm,

Retrieve the User data into the "overall" routine via appropriately-defined Properties of the UserForm,

Create an instance of your Class,

Pass the User data from the "overall" routine to the Class via appropriately-defined Properties of the Class.

Taking the above approach allows the UserForm and the Class modules to remain completely "ignorant" of each other - all communication between the two modules is handled by the "overall" routine. This approach allows you to make internal modifications to either of the modules without affecting the other one.


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

Regards,

Greg M

[techno_gronk]

Thanks for the reply Greg. That is precisely the way I have approached the issue at present and may continue on that line.

I didn't want to reveal my method initially for fear of being growled at .

Tyrone P.

[Greg M]

Hi again,

You're welcome - many thanks for the feedback.

Regards,

Greg M

[Kyle123]

If you wanted to be really fancy and make the overall routine ignorant of the actual implementations of the userform and class, you could create interfaces for both and pass the instantiated objects into the routine. Sort of like manual dependency injection.