Standard module, UserForm Module or Class Module? ??

[kelly mort]

There are some of the Subs that when I call them from the standard module with my userform, I get errors so I have to place them in the userform module. I have not used the class module before.

Can someone point out to me whether I am doing the right thing or not?

Regards
Kelly

 

[dmt32]

Hi,
you can call a procedure in standard module from your userform & work with the forms objects within that code.

- To understand what your issue is, it would be helpful if you post the codes you are having problems with & someone here should be able to offer guidance to resolved.

Dave

 

[kelly mort]

This is the code. I have to call it from the userform module before it works error-free

Sub Test()
Dim Addr As String
Addr = Range("D7:N" & Cells(Rows.Count, "A").End(xlUp).Row).Address
Range(Addr) = Evaluate("IF(" & Addr & "<1,""""," & Addr & ")")
End Sub

 

[dmt32]

Apart from ranges are not qualified - I just created a UserForm & called your code in a standard module & it reported no error.

What error(s) are you getting?

Dave

 

[kelly mort]

Compile error

Expected variable or procedure, not a module

 

[dmt32]

Compile error

Expected variable or procedure, not a module

Have you named the module the same as the Procedure? If so, Name your module something like this Test_Code


Dave