As long as you haven't unloaded '1 you can do this in the activate event of
form 2

Private Sub Userform_Activate()

With Me
.Textbox1.Text = Userform1.TextBox1.Text
.Textbox2.Text = Userform1.TextBox2.Text
.Textbox3.Text = Userform1.TextBox3.Text
.Textbox4.Text = Userform1.TextBox4.Text
.Textbox5.Text = Userform1.TextBox5.Text
.Textbox6.Text = Userform1.TextBox6.Text
End With

End Sub
--

HTH

RP
(remove nothere from the email address if mailing direct)


"mully" wrote in message
...
Hi All

In Excel I have a customer list of Name/Address/ Contact info etc - which
individually appear in text boxes in User Form1 when scrolling down the
list -works OK. For security reasons I want to issue each customer a
permit
to show on entering the premises. I have opened a new sheet in the
workbook
and inserted a new User Form2 with 6 text boxes which are an exact copy
from
User Form1.(which has 37 text boxes)
Is it possible?? when clicking on a customers details in User Form1 that
the
6 text boxes and assume they are numbered 1-6 could link or paste to User
Form2.

Any help much appreciated

Cheers ------ Mully