Userform displaying when Tab key is hit

[mwc48910]

I display a userform when my workbook opens. It is my "splash screen". From there I display other userforms by button clicks. On one userform, VBA does not set the focus to the first textbox. Focus is set nowhere. If I hit the Tab key, VBA displays the "splash screen". On another userform, there is no data entry, just display of information and buttons. If I hit the Tab key on this userform, VBA displays the "splash screen" from there as well. Why is VBA displaying my initial userform when I hit the Tab key on these userforms, and why is VBA not setting the focus on the first textbox on the one userform? The textbox property Tabstop = True and Tabindex = 1.

[BadlySpelledBuoy]

Might be easier to diagnose if we can see the file. Any chance you could attach a desensitized version?

Which control on the form has TabIndex = 0? That's usually the one that takes focus on intialize.

BSB

[mwc48910]

I've been able to narrow it down to because I am opening a workbook to read values from cells and placing the values in the textbox on the form. It appears to be associate with the actual opening of the workbook.
For some reason that is destroying the tabbing. The first textbox does have a tabindex of 0.

[mwc48910]

I found a solution, but I don't understand why it works this way...Say on the splash screen userform, I have a button and the code is

Private Sub CommandButton1_Click()
Workbooks.Open (ThisWorkbook.Path & "\" & "abc.xlsx")
ThisWorkbook.Activate
Me.Hide
UserForm1.Show vbModeless
End Sub

I open the workbook I want to read data from. Then I have to get control back to the workbook where the userform is defined to display the userform in my current workboo. When Userform1 is displayed, this code is ran...
Private Sub UserForm_Activate()
TextBox1.Value = Workbooks("abc.xlsx").Sheets(1).Range("d1").Value
TextBox2.Value = Workbooks("abc.xlsx").Sheets(1).Range("e1").Value
Workbooks("scenarios.xlsx").Close
End Sub

Only then can I read the data from the workbook and place cell values into the textboxes, and the cursor will appear in Textbox1.
I thought I should be able to open and read the workbook during the Userform_Activate, but that will cause the cursor to not appear in textbox1 when the userform is displayed.