I'm creating in Excel VBA a form using code. The following code snippet presents a problem in which the form is somehow created with the name already correctly set and then afterwards, in the only place where I set the said variable, it raises an issue saying that there is a form with that name (the variable in case).
Here is my code:
To be clear, the error is that when it reaches the line:Please Login or Register to view this content.
Somehow it already creates a form with name that's set after at the with statement:Please Login or Register to view this content.
And then, when it tries to run the with statement it breaks and says that a form with that name already exists.Please Login or Register to view this content.
The whole thing is ran at another module as:
The form creation happens inside the ac.CreateCRUDView.Please Login or Register to view this content.
How is it pulling the name variable before it's set and then trying to use it to make another form with the same name?
Bookmarks