Spin Button to call sub every time it changes

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

Please Login or Register  to view this content.

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!

whats missing??? - a workbook !
see big yellow banner - how to upload.