VBA - Simple example for passing a variable between modules

After getting to know VBA quite well there is still one issue I am having, I can't seem to get my head around passing values between modules. I hope someone here might be able to aid me in a simple theoretical example that will help me and hopefully others.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

All I am after is for someone to point me in the right direction on how to pass variable x to the second module, and then return y back to module1 and continue with the new calculated value.

Many thanks in advance!

Ryan.

Thank you very much, highlighted where I was going wrong too. The use of function rather than sub here is key!

Edit: If a mod could close and mark as solved I think we are done here