Passing variables between subs?

**jerseyguy1996** · 11-03-2009, 01:14 PM

Good Afternoon,

I think I am confused as to how to declare a variable in one sub and use it as an input into another sub. I have attached some code below that assigns a value to two variables and then calls a sub that uses those values. I am brand new to programming so I guess I am confused how to implement this. Any help would be appreciated.

Please Login or Register  to view this content.

**shg** · 11-03-2009, 01:43 PM

I reorganized your code somewhat and corrected the Call, but have no way to test it.

Please Login or Register  to view this content.

A significant change is this: You compute a value using NormInv(Rnd() ..., test whether the result is <0, and then store either zero or the computed value -- except you actually compute the value again with a new random number, which will give a different result. I cached the orginal result in dTemp and tested that.

Also, VBA will repeat the same sequence of random numbers after a reset (that's a deliberate and useful behavior). When you're done testing your code, you'll want to add the statement Randomize as the first line to keep this from happening.

**jerseyguy1996** · 11-03-2009, 02:08 PM

Excellent!!! Fixing the call worked perfectly. And thank you so much for cleaning up the rest of the code. I haven't figured out all of the short hand ways to write this stuff so my code is probably about 10 times longer (and slower) than it needs to be.