I know really basic but i cant remember how to save the data entered in textboxes on a userform.
here is the code section of the userform if any1 can help please.
its the red part that confuses me
thanks
chris
Private Sub GN_Enter()
GN.Text = Cells(4, 4).Value
End Sub
Private Sub JD_Enter()
JD.Text = Cells(6, 11).Value
End Sub
Private Sub Rank_Enter()
Rank.Text = Cells(8, 4).Value
End Sub
Private Sub RN_Enter()
RN.Text = Cells(6, 4).Value
End Sub
Private Sub RO_Enter()
RO.Text = Cells(4, 11).Value
End Sub
Private Sub save_Click()
Unload Me ' Close the Form
End Sub
Private Sub UserForm_Click()
GN.Text = Cells(4, 4).Value
RN.Text = Cells(6, 4).Value
Rank.Text = Cells(8, 4).Value
RO.Text = Cells(4, 11).Value
JD.Text = Cells(6, 11).Value
End Sub
Bookmarks