ok thats fair enough but how do i get the information to
be entered onto the second line?

-----Original Message-----
Just have the Next button clear your controls - you don't
have to drop the
userform2 and make it reappear.

--
Regards,
Tom Ogilvy


"Manisha" wrote in
message
...
Hello,
first u enter information in the 1st userform, then u
click nxt and the 2nd userform appears.

ok i have 2 user forms in my workbook. on the 2nd
userform
i hav 2 buttons. one of them is Next and the other is
Finish. Finish takes you back to the spreadsheet.



this info is then automatically entered on to the 1st
line
of the spreadsheet.

i want the "next" button to make the second userform re
appear and all the information from the 1st userform to
be
reentered into the spread sheet.

this is getting urgrent.

pls help if u can.


.