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?
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?
What do you mean by sub routine/ Is this Procedure in a separate module to thw UserForm code?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
In Module 1 I have
Sub SolicitWedding()WeddingSpecialForm.ShowEnd 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
Which would be much easier to find and correct if you useMisspelling an object name or reference can this problem.at the top of each module.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks