how to edit cells using userform command button?

A

Alex Alex

New member
I know only how to find last row, to be able to go back up to four rows to edit the entry .help me please
Code: 
Private Sub CommandButton1_Click()
Dim cLastRow
cLastRow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row
TextBox1.Text = Worksheets("Sheet1").Cells(cLastRow, "A").Value
End Sub
 
Back
Top