Textbox in userform not initialized when workbook opens

[przemek]

Hi


I want to display userform when workbook is opened by user. Userform have 4 Textbox that have to be updated from cells value in Thisworkbook. I started with

Private Sub Workbook_Open()
WelcomeToISC.Show
End Sub

and followed by Initialize code

Private Sub Userform_Initialize()
  
Dim t6, t7, t8, t9 As String
Dim ws As Worksheet
 
Set ws = ThisWorkbook.Sheets("Refresh info")
t6 = “Next update is planned for: “ & ws.Cells(4, 2)
Me.TextBox6.Text = t6
…..
End Sub

result is "Run-time error '424' : Object required." So i have changed Initialize from Userform_Initialize() to WelcomeToISC_Initialize() as per below. Files opens, userform is displayed but nothing is populated into Textbox. FYI there are other userforms in this file, that are triggered from module code.

Private Sub WelcomeToISC_Initialize()
  
Dim t6, t7, t8, t9 As String
Dim ws As Worksheet
 
Set ws = ThisWorkbook.Sheets("Refresh info")
t6 = “Next update is planned for: “ & ws.Cells(4, 2)
Me.TextBox6.Text = t6
…..
End Sub

Thanks for looking at this and you advice.

 

[RoryA]

It should always be Userform_Initialize regardless of the name of the form. The error means you have a mistake in the Initialize code such as using an incorrect control name.