Refering to a userform in a procedure

[Osprey2]

I have a subroutine that will be used several times which needs to refer to a different UserForm each time.
I have not been able to find the code which will allow me to do this.

I was hopeful of :-

Please Login or Register  to view this content.

But this gives an error message "Object required" at the Set line. I am a bit out of my depth and would like some help please
John

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[Osprey2]

Greg,
I have just finished checking out your idea in my context and I am delighted. It all worked perfectly.
Thank you very much for giving me your time and effort.
I am a bit puzzled as to hoiw it works though. Is vbMethod a constant of CallByName?
John

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

The following link might give you some more information about the various CallType arguments used by the CallByName method:

https://bettersolutions.com/vba/func...e-function.htm

Best regards,

Greg M