avveerkar:
And if you have been able to change the name of the form to frmComments
from say UserForm1 please let me know how you did it.
Open the form. Press F4 to bring up Properties. Make sure you're viewing
the Properties for the form itself. One item is (Name) - it's usually at
the very top. Put your desired name there, and it should rename the form in
the Project Explorer.

NickNick:
Check to make sure the form is accessible in the project you're working
with. Did you create the form in a different workbook that's also open?
Have you declared and set an object to frmComments? Have you tried
UserForms("frmComments")? Have you tried to Load first and then Show?

HTH
Ed

"avveerkar" wrote
in message ...

Just check using object browser in VB code that the name is correct and
not UserForm1 or something. In my opinion userForm.name is a read-only
property and cannot be changed. More likely, the name is UserForm1 or
UserForm2 etc. I think frmComments could be the caption of the form and
not name. UserForm1.Show should work.

And if you have been able to change the name of the form to frmComments
from say UserForm1 please let me know how you did it.

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile:
http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=504182