Hi all,

How can i make sure the cursor from textbox A go to textbox C, not textbox B? In every textbox of my userform, there is a procedure where textbox will be disabled once data entered, to make sure no alteration.

But after entered current textbox, the cursor jump to other textbox randomly. I got more than 50 textboxes in one form and this will annoy user everytime they want to key in data. I need it to move to the next textbox automatically after user press "Enter" button on keyboard, so that user can enter next data easily, without have to click with mouse.

Any help are most welcome....

Thanks!!

Hi

The easiest way is to set the TabIndex of the Textboxes in sequence (1, 2,3..).

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi shasur,

thanks for replied. The cursor did not move to the next textbox even when i set those textboxes according to 1,2,3.....

this is because i set those textboxes to be disabled whenever user enter data once, this is for data integrity issue. so i found out another way to make sure the cursor move the next textbox which is by using 'setfocus.'


For example from textbox1 to textbox to:

Private Sub TextBox1_Change()
If Me.TextBox1.Text = "" Then
   Me.TextBox1.Enabled = True
Else
   Me.TextBox1.Enabled = False
   Me.TextBox2.SetFocus
End If
End Sub

With this 'SetFocus', cursor will move to the specified textbox. Hope this helps other friends who faced with this problem as well....

Cheers,
Mona

This was helpful to me. Thanks.