Say I have a worksheet
Number | First Name | Last Name as the column labels
then a variable amount of data
for this example:
Number First Name Last Name
1 John Doe
2 John Smith
3 Kelly Scott
4 Andrew Clarke
example1.JPG
I need help with a user form that populates certain text boxes based on the data with each row.
Each time you click a button "next" the data goes to the next row of data.
example2.JPG
So when the form initializes, it has
Number: 1
Name: John Doe
you click the next button, and it populates
Number: 2
Name: John Smith
and does this until the last row of data.
Any suggestions?
Bookmarks