A Sub in another Sub...

  • Thread starter Thread starter Traima
  • Start date Start date
T

Traima

Hi,

I have a rather basic question: I have made two macros in vb that works out
just fine one by one. Now I need to include one macro into another. I need
the macro called Sub EnterMonthYear to be included at the very end of the Sub
Table

I'm sure there's a simple code to trigger the Sub EnterMonthYear, but I
can't seem to find an answer anywhere..


The programming is like this:

Sub Table ()
..
..
*
End Sub

Sub EnterMonthYear
Dim MyMonth as String
Sheets("Inputsheet").Range("x6").Value=InputBox("Enter month")
Dim MyYear as String
Sheets("Inputsheet").Range("Y6").Value=InputBox("Enter year")
End Sub

Thankful for a response!

Traima
 
Use the Call Statement which transfers control to a Sub procedure, Function
procedure, or DLL procedure..

Call EnterMonthYear
 
Back
Top