Userform Back and Next Button

[asjmoron]

I wonder if you guys can help me (once again).

I have a userform that is used for data entry and would really like to have the functionallity to have displayed the data from the last record and then then option to click "forward or back" to see the other entries. Once on them, i would like to be able to edit them, almost in the same way the built in Form allows you too but within my own userform... this is probably a bigger ask than I think but any advice would be great.

 

[Yongle]

To give you something easy to tailor, it would be helpful to understand the following

unique reference make-up and length
Each record must have its own unique reference number...
Please provide 3 references
- the first
- one from the middle of your data
- the last

number sequencing rules
Is each reference numbered consecutively?

where to find the unique reference and number of columns
- is the unique referencer in column A?
- which is the last column?

 

[asjmoron]

So there is a set amount of entries, it is always a form that must have the same 447 rows of set data entered (it sort of quesionairre sort of form). it is built accross a:j. I can add a reference column and label it 1 - 447 as these are the constant.

The reference can be added to A, so lets assume the answer is yes, the unique referencer is in column A.

Does that help?

 

[dmt32]

Hi,
have a look here:https://www.mrexcel.com/forum/excel-questions/939934-next-previous-button-code-2.html

#Post 17 & see if this helps you

Dave