Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Dec 18, 2024
Solved

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    
excel
Macros and VBA
  • sf49ers19238597's avatar
    sf49ers19238597
    Dec 19, 2024

     

    Private Sub FORM_WEEKLY_SCHEDULE_Click()
VIEW_WEEKLY_SCHEDULE_FORM.Show
End Sub

     

     

     

     

Kidd_Ip's avatar
Kidd_Ip
MVP
Dec 19, 2024

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
Dec 19, 2024

 

Private Sub FORM_WEEKLY_SCHEDULE_Click()
VIEW_WEEKLY_SCHEDULE_FORM.Show
End Sub

 

 

 

 

Resources