Userform field to show existing string with ability to change.

Hi all,
I have a user form which is programmed using VBA. It has "NEXT" and "PREVIOUS" buttons which can move up and down rows in the spreadsheet and show the relevant values, and an "ADD" button which enters the new information into the current active row.

Here is an example of what I am trying to achieve -

The user writes this sentence in (text box A) "I Have A Dog", then presses "ADD", this is then entered in Cell A1. When the user then presses the "NEXT" button to go to the next row, I need (text box A) to still read "I Have A Dog" and not be blank so all the user has to do then is press the "ADD" button to enter this sentence into the now cell A2. This process continues until the user changes (text box A) and it now reads "I Have A Cat" and the user then presses "ADD" to enter this into the CurrentRow, Column A.
I now need this to be the sentence that appears in (text box A) when the user goes to the next row.

Can anyone help me with this problem?

Thanks

Yappa

Yappa

How is the textbox being cleared in the first place?

Hi,

Sorry about the delayed response, had to get some sleep.

Norie, the text box is clear because when the next button is pressed, it is showing the value in an unused cell, which is why I need it to show the current value from the previous row, cell.

Shijesh Kumar, Thanks for your response. Your code worked with some modifications. My problem was I was concentrating on the "ADD" button and not on the "NEXT" button. Your direction and thinking was just what I needed, thanks greatly.

Yappa.