Urgent - how to run textbox exit sub?
 

I have a sub behind a textbox in a VBA form like this:

Private Sub txtIncPercent_Exit(ByVal Cancel As MSForms.ReturnBoolean)
...
End Sub

How can I run the above sub from another sub?

Regards,

S

Urgent - how to run textbox exit sub?
 

Call txtIncPercent_Exit(True)
or
Call txtIncPercent_Exit(False)

wrote:
I have a sub behind a textbox in a VBA form like this:

Private Sub txtIncPercent_Exit(ByVal Cancel As MSForms.ReturnBoolean)
..
End Sub

How can I run the above sub from another sub?

Regards,

S

Urgent - how to run textbox exit sub?
 

Dim ans As Boolean
Call TextBox1_Exit(ans)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I have a sub behind a textbox in a VBA form like this:

Private Sub txtIncPercent_Exit(ByVal Cancel As MSForms.ReturnBoolean)
..
End Sub

How can I run the above sub from another sub?

Regards,

S

Urgent - how to run textbox exit sub?
 

I receive an error message telling me "Incompatible types". What is
that?

Regards,

S


John skrev:

Call txtIncPercent_Exit(True)
or
Call txtIncPercent_Exit(False)

wrote:
I have a sub behind a textbox in a VBA form like this:

Private Sub txtIncPercent_Exit(ByVal Cancel As MSForms.ReturnBoolean)
..
End Sub

How can I run the above sub from another sub?

Regards,

S

Urgent - how to run textbox exit sub?
 

I still get the same message...

Regards,

S


Bob Phillips skrev:

Dim ans As Boolean
Call TextBox1_Exit(ans)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I have a sub behind a textbox in a VBA form like this:

Private Sub txtIncPercent_Exit(ByVal Cancel As MSForms.ReturnBoolean)
..
End Sub

How can I run the above sub from another sub?

Regards,

S