Hi everyone!

I hope you are well. I have a spin button on my sheet, linked to a name range on another sheet ("LookUps"), to sort some data and I wish to call a sub every time it changes. Here's my code

Private Sub sortSpinButton_Change()
    sortTextBox.Value = Worksheets("LookUps").Range("sortBy").Item(sortSpinButton.Value)
    Call sortSht(sortSpinButton.index)
End Sub
Every time the user presses the spin button, the "sortTextBox" displays the preference and the sortSht sub executes. However, if the user press a second time either of the spin buttons (Up or Down), the preference displays correctly in the text box but nothing happens.

What am I missing?


Many thanks for your support!