ok, let mi see if i understood what you want
You have an UserForm and two worksheets; what you want is to write something in worksheet 1, then load the user form, click a button so the text in worksheet 1 appears in worksheet 2 and then unload the form.
And you also want that next time you load the form, it shows the text in worksheet 2??
Well, first of all, lets imagine the user form has a CommandButton and a TextBox.
What you have to do is to doble click the user form and go in the upper right menu to where it says "initialize". there you should write something like:
- Private Sub UserForm_Initialize()
-
TextBox1.Text = Worksheets(2).Cells(1,1).Value
-
End Sub
Then double click the command button, and there you should have something like
- Private Sub CommandButton1_click()
-
worksheets(2).cells(1,1).value = worksheets(1).cells(1,1).value
-
end sub
And there you go... this will do for the cell A1 in both worksheets, you can always generalize it to any range.
Good Luck
Kad
17
