A "previous" button on a user form
 

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

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

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

--

HTH

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


"Anthony Slater" wrote in message
...
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

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.

"Bob Phillips" wrote:

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

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

--

HTH

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


"Anthony Slater" wrote in message
...
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

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)


"Anthony Slater" wrote in message
...
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.

"Bob Phillips" wrote:

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

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

--

HTH

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


"Anthony Slater" wrote in
message
...
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