User Form Won't Load

So I have a form called WeddingSpecialForm and a sub routine that consists entirely of the line WeddingspecialForm.Show but when I run the sub routine, I get a type error. Does anyone have any hypotheses why?

I think a skosh more information, some code, an example, would help.

It's on another machine that I'm keeping as an isolated system, but there's a fair amount of code for the form. What areas would you recommend looking in?

In Module 1 I have

Sub SolicitWedding()

WeddingSpecialForm.Show

End Sub

Under forms I have a form called WeddingSpecialForm

Are you saying I should but the sub in the code for the form?

Hello Suburbanght,

You're correct in that the code to call the UserForm should be in Module 1. I would check your code for a typo. Misspelling an object name or reference can this problem.

Sincerely,
Leith Ross

Misspelling an object name or reference can this problem.

Which would be much easier to find and correct if you use

Please Login or Register  to view this content.

at the top of each module.