Linking subs

[gregv]

Hi,
I am teaching myself excel VBA and at present, everything I write, is done in one sub. There are certain sections of my code that I need to repeat several times in the sub. Is there a way I can put those lines in another sub (or area) which I could link into (and out of) each time I need that calculation carried out?
Sorry if it's an obvious or daft question! - Thanks

 

[phantom1975]

Here's another tidbid that you will most likely need if you plan on "linking" subs together. That is passing a variable from one sub to the next.

Sub Macro1()

Dim My_String As String


    My_String = InputBox("What's your name?", "ENTER YOUR NAME", "Billy")
    
    Call Macro2(My_String)
    
    MsgBox "That was thrilling, wasn't it?", vbQuestion + vbYesNo + vbDefaultButton2, "YEE HAW"
    
    
End Sub


Sub Macro2(Passed_Variable As String)


    MsgBox "Good day to you " & Passed_Variable


End Sub

 

[Venom]

Is it possible to Call an individual Sub inside of another Module?
say, from Module1... call the 2nd Sub in Module2?

 

[phantom1975]

Absolutely. Just make sure that the sub isn't a Private sub

Public Sub Macro1 = Available anywhere in the project. Able to be seen in the macros list if you wish to play a macro from a worksheet using the Excel menu.

Sub Macro1 = Same thing as Public

Private Macro1 = Only available within the module. Not seen in the macros list.

 

[Venom]

This seems to work;

Sub Test1()

Call Module1.Sub2

End Sub

 

[phantom1975]

No need to include the module name in your call procedure. You cannot have two macros with the same name within the same project.