Auto close a UserForm 1

[gregmosu]

I have a Userform for Excel that opens first and tests the database connection. If the connection can be established, I want to close that userform and open a new userform. So far, all I can do is hide the first form. Is there a way to close it?

UserForm1.Hide
UserForm2.Show

Thanks!

 

[RonRepp]

Try:

Unload UserForm1

Hope this helps.

Ron