how to access a doubleclick, need to call it from another macro

[dmcgov]

i have the following:

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
UserForm2.Show
TextBox1.Value = UserForm2.TextBox1.Value

that works. now i want to call the dblclick from another macro, how can i do that?

[mehmetcik]

If your Macro is

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
UserForm2.Show
TextBox1.Value = UserForm2.TextBox1.Value
End Sub

Then Create a new Macro in a normal Macro Module.

Sub TDC()
UserForm2.Show
TextBox1.Value = UserForm2.TextBox1.Value
End Sub

Modify your Macro to:-

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
TDC
End Sub

So now you can call the Macro using: TDC

For example:

Sub Macro1()
TDC
End Sub