Using a Spin Button for Text in Cell range

[mjayz]

Hi

I am trying to use a spin button to toggle through a list of names in Column A. e.g A1 to A25 (and probably adding more later) has peoples names in the cells. I want to display one name at a time in cell B1 and to run up and down the list with the spin button.

Any help would be appreciated.

Thanks

 

[Andrew Poulsom]

Set the LinkedCell property of your SpinButton to say C1. Then in B1 enter:

=INDEX(A1:A25,C1)

 

[mjayz]

That's great. Thanks for your help!!
MJ