Call double click event of another control 1

[mintjulep]

How do you call the double click event of a control from another procedure?

Private Sub textbox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

A bunch of statements that work

End
End Sub

Private Sub Button1_Click()

If checkbox1.Value = -1 Then Call textbox1_DblClick()

End Sub

If I try

Call textbox1_DblClick

I get "Argument not optional"

If I try

Call textbox1_DblClick (0)

or

Call textbox1_DblClick (false)

or

Call textbox1_DblClick (true)

I get "type mismatch"

What does it want?

 

[rmikesmith]

Try the following:

Private Sub CommandButton1_Click()
Dim Cancel As MSForms.ReturnBoolean
   
   If CheckBox1.Value = -1 Then Call TextBox1_DblClick(Cancel)
End Sub

Just don't try to use Cancel in the CommandButton handler or change its value in the TextBox DoubleClick handler. Both produced errors.


Regards,
Mike

 

[mintjulep]

Perfect. Thanks.