J
JT
I have a user form wtih 10 textboxes where the user can enter an amount in 1
or more of the textboxes.
I am using the following code to format the textbox after the update:
Sub TB01_AfterUpdate() ' first textbox
frm_TaxEntry.TB01 = Format(TB01, "$ ##,##0.00")
End Sub
This seems to work good. The problem is if I tab out of this textbox, the
cursor moves to the 3rd textbox instead of the 2nd one. The crazy thing is
if I use the "Enter" button to exit the textbox, the cursor goes to the 2nd
one; which is what I want it to do.
How can I make the cursor go to the 2nd textbox when I tab out of the first
one?
Thanks for all of your help......
or more of the textboxes.
I am using the following code to format the textbox after the update:
Sub TB01_AfterUpdate() ' first textbox
frm_TaxEntry.TB01 = Format(TB01, "$ ##,##0.00")
End Sub
This seems to work good. The problem is if I tab out of this textbox, the
cursor moves to the 3rd textbox instead of the 2nd one. The crazy thing is
if I use the "Enter" button to exit the textbox, the cursor goes to the 2nd
one; which is what I want it to do.
How can I make the cursor go to the 2nd textbox when I tab out of the first
one?
Thanks for all of your help......