Juraj
07-25-2017, 09:06 AM
I have an Excel worksheet with two forms Form1 and Form2. Form1 has TextBox1 with DoubleClick event:
Public Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
' Some activity...
End Sub
Form2 has CommandButton2 with Click event:
Private Sub CommandButton2_Click()
' Another activity...
End Sub
I need call TextBox1_DblClick Sub from CommandButton2_Click Sub. What are exact code and parameter type for this calling?
Public Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
' Some activity...
End Sub
Form2 has CommandButton2 with Click event:
Private Sub CommandButton2_Click()
' Another activity...
End Sub
I need call TextBox1_DblClick Sub from CommandButton2_Click Sub. What are exact code and parameter type for this calling?