There are 4 different ways in Module to call a procedure. To show it how it works, a Module taken from Insert | Module as Module1 and again taken from the same way Module2 in VBA Environment.
Way 1 - Written in Module1:
Simple procedure calling in a Module:
Way 2 - Written in Module1:
Call a procedure withing another procedure in the same Module:
Way 3 - Written in Module1:
Call a procedure withing another procedure but new calling technique in the same Module:
Note: You can test your procedure in Immediate window.
Way 4 - Written in Module 2:
Call a procedure withing another procedure from different Module:
Save the file as .xlsm and exit for today.
Way 1 - Written in Module1:
Simple procedure calling in a Module:
Sub new_player() Range("A1").Value = "Balak" End Sub
Way 2 - Written in Module1:
Call a procedure withing another procedure in the same Module:
Sub player_come_coach() new_player End Sub
Way 3 - Written in Module1:
Call a procedure withing another procedure but new calling technique in the same Module:
Sub coachRetired() Call new_player Range("H1").Value = "Was a Captain of Germany Football Team" End Sub
Note: You can test your procedure in Immediate window.
Image 1: Calling a procedure within a same Module (Module1)
Way 4 - Written in Module 2:
Call a procedure withing another procedure from different Module:
Sub coachRetired() Call new_player Range("H1").Value = "Was a Captain of Germany Football Team" End Sub
Image 2: Calling a procedure from another Module (Module 2)
Save the file as .xlsm and exit for today.