Hi CFD,

I could not reproduce your error and

Private Sub CommandButton1_Click()
UserForm2.Show
End Sub

worked for me.


---
Regards,
Norman



"CFD" wrote in message
...

Ok, this is such a rediculously simple problem, I am almost too
embarrassed to ask. After searching high and low, I cannot for the life
of me figure out how to display one userform, when a user clicks on a
button in another?

A simple Userform2.show does not work- the code breaks with an "object
required" error.

I know I'm going to kick myself when I see the answer ... (can you
delete topics you stated yourself so i can hang my head in shame?)


--
CFD


------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=473653