Can 100 Form Controls be handled all at once?

[Monsignor]

The challenge is in putting 100 spin boxes in 100 consecutive rows and having them assigned (Cell Link) to their respective rows (C10, C11, C12, ...). Must this be done one at a time?

What would be an efficient way to put them in position and assign them?

 

[Trevor G]

Try recording a macro to create the spinner and link to the cell, then you have the code that you should be able to adapt to achieve your goal.