User Form Help

[MontySharpei]

Is it possible for a userform to be created which ask for say three inputs ie. three surnames:,

which when entered populates three cells on sheet 1 say cells a1, a2, a3
and three cells on sheet 2, say c1,c2,c3 ?

sheet1 cell A1= sheet2 cell C1
sheet1 cell A2= sheet2 cell C2 etc etc ???

[marshybid]

Hi there,

See the reply from Lucas to the thread below.

http://www.vbaexpress.com/forum/showthread.php?t=20415

I have looked at the code in the example workbook provided by Lucas and you could easily modify this to your requirements.

Marshybid :hi:

[Simon Lloyd]

In your userform command button code use the follwoing provided you have 3 textboxes

Sheets("Sheet1").Range("A1").Value And Sheets("Sheet2").Range("A1").Value =Userform.TextBox1.Value
Sheets("Sheet1").Range("A2").Value And Sheets("Sheet2").Range("A2").Value =Userform.TextBox2.Value
Sheets("Sheet1").Range("A3").Value And Sheets("Sheet2").Range("A3").Value =Userform.TextBox3.Value