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.