Thread: skips controls
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default skips controls

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......

--
JT