How can I call a Module or a sub procedure and run it automatically in current module?

Thanks!!
But what about this one, I tried, however it doesn't work, why?

Application.goto reference:="procedure_name"