How to use a module value in a userform?

[whcmelvin]

In my userform, i already called for the subroutine in Module 3.
But i can seems to print the module 3 value in my userform. they gave me an error "Method or data member not found.
Please help me. Thanks

This is the codes in module 3

UnPandL = Buy.LotsBuy.Value * 100000 * (Cells(n, 2).Value - Buy.RateBuy.Value)

This the codes in my userform

Cells(n1, 1).Offset(0, 9).Value = Module3.UnPandL.Value

 

[bensonsearch]

try removing .value at the end of the last bit of code

 

[whcmelvin]

Hi, it doesn't help.

 

[bensonsearch]

have you tested to see if the variable has data in it? not an error or blank? press F8 and go through the code, hover over the variable after the yellow line and see what value it is

 

[whcmelvin]

There is a value in the module. But when using it for userform, it does not have any value

 

[GTO]

In my userform, i already called for the subroutine in Module 3.
But i can seems to print the module 3 value in my userform. they gave me an error "Method or data member not found.
Please help me. Thanks

This is the codes in module 3

UnPandL = Buy.LotsBuy.Value * 100000 * (Cells(n, 2).Value - Buy.RateBuy.Value)

This the codes in my userform

Cells(n1, 1).Offset(0, 9).Value = Module3.UnPandL.Value

How and where is UnPandL declared? At the top of the module, or within a procedure? Dim or Public?

When you type "Module3." does intellisense show UnPandL?