Command button code to write to worksheet and then open userform

Need a bit more help please.

I have the following code on the command button to insert data on a worksheet. After the data is inserted I then want it to open UserForm2 and close Userform1. Not sure what code I need and where to enter it.

Please Login or Register  to view this content.

Thanks Seamus,

This works perfectly.

Mandy