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