Userform output to cell

[fezzer]

I'm sorry if this has already been covered - I couldn't find an appropriate thread.

Basically the situation is this. I'm in Excel and have set up a user form which is activated with a button. There are a load of simple text fields which will get filled in. These will then be put into certain cells when the ok button is pressed. Should be easy i know.... Oh and is it possible to set the default value of each field as the present value of that cell so if the user makes a mistake it can be loaded up again and they'd only have to correct that one field.

Thanks

Fez

 

[Zathras]

Here's one way:
[blue]

Private Sub UserForm_Initialize()
  TextBox1.Text = [A1]
  TextBox2.Text = [A2]
  TextBox3.Text = [A3]
End Sub

Private Sub CommandButton1_Click()
  [A1] = TextBox1.Text
  [A2] = TextBox2.Text
  [A3] = TextBox3.Text
  UserForm1.Hide
End Sub

[/color]