Running a module with a macro

[Frank]

My team is working with a simple module that imports data from a Word
document. We completed the module now we need to make it user friendly
enough for the masses to use.

We're attempting to create a simple command button to run the module, so I
assume we need to write a macro to run this module. This is the part that
has us stumped. Any suggestions?

 

[Ken Snell [MVP]]

You don't necessarily need a macro for doing this, as you could use VBA code
to do it too (which it appears that you've already used to create the
module).

What you do is create a command button on a form. Use the button's Click
event to run simple code:

Private Sub CommandButtonName_Click()
Call NameOfTheModuleSubroutineProcedureThatIsToBeRun
End Sub