A "previous" button on a user form

A

Anthony Slater

With the help of this forum, I've managed to build quite a decent little user
form for data entry.

Basically, after my user form has been filled in, a button is pressed that
finds the next blank row in a worksheet and fills in the details accordingly.
The form then resets and awaits a new entry.

How can I add a button that diplays the previous entry?

TIA
 
B

Bob Phillips

I presume that you just want to know how to get the last entry

cLastRow = Worksheets("Sheet1").Cells(Rows.Count,"A").End(xlUp).Row

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Anthony Slater

Bob

After the button on my user form is pressed, the values are added to my
worksheet.The user form is then reset ready for another entry.

What I want is another button for user form to be re-populated with the last
entry so the person inputting can double check the last entry for errors.
 
B

Bob Phillips

The code I gave gets the last row, so you would use something like

Textbox1.Text = Worksheets("Sheet1").Cells(cLastRow,"A").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top