Sub xxxx()
file1_click
End Sub
Sub sub2(m As String)
MsgBox m
End Sub
'form2
Private Sub command1_click()
Dim l As String
l = "xxxx"
CallByName Form1, l, VbMethod
l = "sub2"
CallByName Form1, l, VbMethod, Date - Rnd * 100
End Sub
Private Sub Command1_Click()
Dim L As String
L = "sub1"
CallByName Form1, L, VbMethod
L = "sub2"
CallByName Form1, L, VbMethod
L = "sub3"
CallByName Form1, L, VbMethod
End Sub
Public Sub sub1()
Debug.Print Now, "Sub1"
End Sub
Public Sub sub2()
Debug.Print Now, "Sub2"
End Sub
Public Sub sub3()
Debug.Print Now, "Sub3"
End Sub