Error when i give a name to a UserForm

[pierre08]

Hi guys,
i'am trying to creat a new UserForm with code and i would like to give it a name, here's the code, every time i receive the error code "75" error with the path...
I have trid the two codes, and i have the same error for both of them:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Does anyone see where is the error???

Thanks for your help.

[contaminated]

Try this....

Please Login or Register  to view this content.

You cannot use the constant vbext_ct_MSForm without early binding.

Source http://www.mrexcel.com/forum/showthread.php?t=51412

[pierre08]

The error that i have is in the line:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

The macro create the userform but doesn't succed to give it a name

[pike]

Hi pierre08

Please Login or Register  to view this content.

[pierre08]

Doesn't work i have the same error

[pierre08]

Now i have 2 errors the same number of error '75' but another description: specific object not found

[pierre08]

It doesn't work i still have the same error in fact if crate the userform but when it attend the line of the name propriete it give me the error.
Is there another way to name the userform or where is the error in the code.

[pike]

dude
try running this code as it works

Please Login or Register  to view this content.

it should have created pTest userform

[pierre08]

It works i don't know what changed i just restart my computer
Thanks for your help guys

[pierre08]

I have just one more question:
is there a code that can verifie if the Name you're giving to a userform is use or not??

[pierre08]

Found it:

Please Login or Register  to view this content.

[pike]

well done

I was playing with

Please Login or Register  to view this content.