I am following a suggestion to start over with my form and make it multipage.
On page one the TabIndex settings work and the cursor tabs through the textboxes in the desired order. On page 2 I have two CommandButtons and 20 textboxes. I have set the TabIndex numbers to tab from textbox1 to commandbutton2, to textbox49, to commandbutton11, to textbox50 through textbox67.
However, the cursor tabs from from textbox1 to commandbutton2, FROM COMMANDBUTTON2 TO TEXTBOX 50, skipping textbox49 and commandbutton11. I have tried to intercept the tab key press on commandbutton 2 with the following code to force the cursor to move to textbox49.
Private Sub CommandButton2__KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyTab Then
However, when I step through the code, this Sub is not accessed and the cursor does not go to textbox49. If I move the cursor to textbox49, then click Tab, the cursor moves to textbox50. If I move the cursor to commandbutton11, then click Tab, the cursor moves to textbox50.
I will happily attach code if that will be helpful.
Suggestions will be appreciated.