need simple VBA help

[SKV]

I am very new to VBA so need help to call a SUB in another SUB

Below is my sample code where I want to run "Sub Testing()" from "Sub RunSteps()" but not getting the desired result. infact code is running without error but not running "Sub Testing()". Please advice how to write the code. All of my subs are in the same module.


Sub RunSteps()

DoCmd.SetWarnings False


'DoCmd.RunMacro "DataPrep-Step1" ' prepare table TB40 with initial data load

DoCmd.OpenModule "RankingProcedure", "Testing"
DoCmd.SetWarnings True
MsgBox "Completed"

End Sub
Sub Testing()
MsgBox "Heloo"

End Sub

 

[SKV]

I believe I got my answer - I should have use "Call" to run the sub. it is working now.

Let me know if there are any other ways.

thanks