VBA to pass a value

[rcerda]

Hi,



I need to pass a value generated whenever a sub is processed (a boolean True/False) and check its value in another function to have it take some action in case is True. I have tried with ByVal, ByRef but have not been successful. Whenever I go check the value in the function I need the value is Null so I can not complete the algorithm. I would appreciate if someone knows how to keep the value from one sub to a function.

thank you

[orange]

Show us your function and sub. Hopefully there is some description with each.

[pbaldy]

You can declare the variable in a standard module, so its value is available at any time. You can also have your sub be a function and have it return the true/false value.