Adding a value textbox to a userform

You can only have one initialise event per userform.
the third row in code below reads the cell AM1 in sheet2
see demo file

Option Explicit

Private Sub UserForm_Initialize()
LoadComboBox 
ClearForm
Me.TextBox1.Value = Sheet2.Cells(1, 39).Value
End Sub