Eroor Passing Variable Between Module and Userform

[Jenn68]

I am trying to pass a variable (etr) between a module and a userform ...

The module calling the userform ...

Please Login or Register  to view this content.

The userform initialization code ...

Please Login or Register  to view this content.

I am getting a compile error ... "Procedure declaration does not match description of event of procedure having the same name"

Is anyone able to help me undersatnd where I have gone wrong?

[Norie]

You can't alter the Initialize event declaration, you'll need a different approach to 'pass' the variable to the userform.

How are you going to be using the variable?

[TMS]

You probably just need to declare a public variable at the top of the module. Then set it in one subroutine and use it in the other.

[Jenn68]

Thank you all for the quick replies!
I'll declare the variable as public. That should work.

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.