AnsweredAssumed Answered

User Form not showing?

Question asked by John Boire on Mar 14, 2018
Latest reply on Mar 14, 2018 by Christian Chu

Okay so here is my issue:

 

I made a form named "UserForm1"

 

then in my Sub main() I have the following line:

 

Dim Form As Object

Set Form = New UserForm1

Form.Show

 

When I run this macro to test it I get "Object required" error
I have also done the following variations

 

Dim Form As New UserForm1

Form.Show

&

Dim Form As New UserForm1

Set Form = New UserForm1

Form.Show

 

I also thought that maybe there was a corruption or something of the form so I basically copied all the contents onto a new userform and let vba name it automatically but I am still getting the same error.

Outcomes