Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Dec 18, 2024

I add userform to my file it not open but give runtime 9 error

I add userform to my file it not open but give runtime 9 error

 

 

I can not config out why not working.

 

 

 

Thanks You

 

 

  •  

    Private Sub FORM_WEEKLY_SCHEDULE_Click()
    VIEW_WEEKLY_SCHEDULE_FORM.Show
    End Sub

     

     

     

     

  • Try this to avoid the error:

     

    Private Sub UserForm_Activate()
        ' Initialization code here
        ' Example: Ensure all controls are properly initialized
        Me.TextBox1.Text = "Initialized"
    End Sub

     

    • sf49ers19238597's avatar
      sf49ers19238597
      Iron Contributor

       

      Private Sub FORM_WEEKLY_SCHEDULE_Click()
      VIEW_WEEKLY_SCHEDULE_FORM.Show
      End Sub

       

       

       

       

Resources