Creating a Database with UserForm VBA Coding

[Ashna1994]

Hi all,
I am on the verge of completing my project in Excel where users key in data into fields (in user form) and data gets automatically updated into a database sheet.
I have added all buttons necessary like text, command, option buttons.
Now I am looking at adding a button so that in the user form,
users can go to previous data and then back to current ones.. I think it is achievable with spin button < > but I am not sure how to code for it.

I have two frames in the userform.
In the first frame, users enter the data, the second frame is list box, coded so that whatever data is added, they can view.

I just want the whole form (all data in frame 1) to go to past records when I press the < button and back until current records when I press > button.

Please help.
Thanks so much in advance.

 

[Bill Williamson]

Hi all,
I am on the verge of completing my project in Excel where users key in data into fields (in user form) and data gets automatically updated into a database sheet.
I have added all buttons necessary like text, command, option buttons.
Now I am looking at adding a button so that in the user form,
users can go to previous data and then back to current ones.. I think it is achievable with spin button < > but I am not sure how to code for it.

I have two frames in the userform.
In the first frame, users enter the data, the second frame is list box, coded so that whatever data is added, they can view.

I just want the whole form (all data in frame 1) to go to past records when I press the < button and back until current records when I press > button.

Please help.
Thanks so much in advance.

Did you ever get any help with this issue?