I want to create a vba or a command button rule that either highlights a cell from a selected range or shows the selected cell in a different cell.

More specifically, i have 7 names in cells A1:A7. I want everytime I run the code, to get the next available name on the list (either highlighted or shown in a different cell). When the selection reaches A7 which is the last cell, then i want it to go back to cell A1 and start all over again.



What code can i use? And is it better on a vba or on a command button?

Thank you

Moved to VBA forum

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sub SelectLastName()

Dim ListRange As Range

Set ListRange = Range("A1:A7")

Range("B1") = ListRange.End(xlDown).Value

ListRange.End(xlUp).Select
End Sub