Return Variable Value

[motabrasil]

People

I have a macro with several Userforms. And, from one of them, I calculated some values and save the result into the variable "Z", as described below:

Z = Z + (Cells(Rw, colPQuantity) * Cells(Rw, colRUnitPrice))

Now, I need to capture that "Z" value using another Userform and Paste into a specific cell like:

Set ws = Worksheets("Total")
ws.Cells(4, "L").Value = Z.Value


How to do that?

Thanks

 

[jasonb75]

Declare the variable Z as global, example

Global Z As Long

this should ideally be in a standard module.

 

[Norie]

Why do you need to 'capture' the value with another userform before you put it on the worksheet?

What exactly is Z? You say it's a variable but variables don't have properties like .Value.

 

[motabrasil]

Basically, because I have in that Template several Userforms. In one of them I calculate "Z" for a specific purpose. After that, if the user need, he can use the same "Z" value for another purpose. So he just need to select the new userfom and capture the "Z" value for this.

Thanks