Next and Previous Buttons using Data Validation List

Question

I have a typical data validation list in cell "P3" with about 28names to choose from. I'd like to have two buttons on the spreadsheet next to the drop down list that will allow the user to select the next name (i.e. open the dropdown list and scroll down one name) and the other button that will be called previous (i.e. select the dropdown list and scroll up one name).
Cells P2 and P4 respectively contains:
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)-1<1,Sheet1!$G$28,MATCH(P3,Sheet1!$G$2:$G$28,0)-1))
=INDEX(Sheet1!$G$2:$G$28,IF(MATCH(P3,Sheet1!$G$2:$G$28,0)>ROW(Sheet1!$G$28)-ROW(Sheet1!$G$2),Sheet1!$G$2,MATCH(P3,Sheet1!$G$2:$G$28,0)+1))

Guidance required!

Note: I am already using a Macro to print all result cards on one click.

Answer 1

Hello Mr. Ian,

Thank so much!

I don't know personal request is allowed here or not!

Actually I am new to VB so can't follow the method. Can you pls solve this problem for me?

Sample file is here

Sample File

Answer 2

Hi M, hope you're doing well. I’m Ian, and I’m happy to help you today.

It is quite tricky based on the data you have right now.

But since you already have the formula for the Previous and Next Data, you just need to call this one for the Next and Previous button that you have.

In the code, this will look something like this one.

Private Sub NextBtn_Click() 'moves to next
Range("P3") = Range("P4")
End Sub

Private Sub PrevBtn_Click() 'moves to previous
Range("P3") = Range("P2")
End Sub

This is a user-to-user support forum and I am a fellow user.

I hope this helps, but please let me know if you need anything else.