Passing arg to UserForm to use in Initialize

Hi all,

I have a UserForm that already has some Initialize code in it. In this Init code, I want to use a Date that is pulled from a regular Module.

So in my regular Module, I have a variable, dInputDate. I want to pass this to the Userform so that the Init code can use it.

I tried putting this in my UF code:

Please Login or Register  to view this content.

then, I used dInputDateUF in my Init code...
then, in my regular module, I have:

Please Login or Register  to view this content.

hoping that it would first call the Let property, but it doesn't...it calls the Init first. So, my data is not passed on via the Let before the Init.

What is the proper way to do this? I know I can do public vars and stuff, but I want to know the correct way.


Thanks,
Joe

Yea, I guess I can just use the Activate event. Actually, it might be more appropriate for what I'm doing anyway since I might want to "re-initialize" when showing the UF a second time.


Thanks,
Joe