The order in the original looked fine to me. What is the advantage or
rightness of doing various lines of code prior to unloading userform1?

--
Regards,
Tom Ogilvy




"Bob Phillips" wrote in message
...
in essence yes, but get the order right

sub finnish ()

various lines of code

unload userfrom1

userfrom2.show

end sub


--
HTH

Bob Phillips

wrote in message
oups.com...
thanks so would having a button on userform 1 that calls a module that
first unloads form1 then opens form2 would be ok
ie.

Private Sub CommandButton6_Click()
Call finnish
End Sub


sub finnish ()

unload userfrom1

various lines of code


userfrom2.show

end sub