Starting a Module from a Userform

[Cease]

Hi,
I have a userform that runs a macro from code set on individual worksheets.
What I'd rather do is have it run from a module, so I can use the same module for multiple sheets.

I have this:

 If ActiveSheet.Range("h224").Value = "T" Then
            Range("D3:I3").Select
            ActiveCell.Value = Range("AK8").Value
            Run ("Sheet5.Mailout")
        End If

How to I change this to run a module (same name: Mailout) instead of from the sheet.

I apologize in advance, I know this is basic, but I'm burned out from a previous search and haven't been able to find the answer to this anywhere else.

Thanks in advance!

 

[Norie]

If the code is not in a sheet class module just remove Sheet5.

You might also need to change how the sub from Private to Public.

By the way, I'm assuming it is an actual Sub you are referring to and not the name of a module.

If the module is called Mailout you'll need to use the name of the sub within the module, which shouldn't have the same name as the module.

 

[Cease]

Norie,

That nailed it. Not sure what I had been trying, but I was overcomplicating it.

Thank you so much!