Userform Back and Next Button

asjmoron

Board Regular
Joined
Apr 26, 2016
Messages
98
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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?
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top