Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Filter skips first row | Excel Discussion (Misc queries) | |||
How do I set it so my tab key skips to the next cell not 6? | Excel Discussion (Misc queries) | |||
Amortization with up front skips | Excel Worksheet Functions | |||
can't tab to next cell skips to end of line? | Excel Discussion (Misc queries) | |||
How come when I hit tab in excel it skips several cells? | Excel Discussion (Misc queries) |