Auto sort macro for spin button event

Hello!

I have learned how to create an auto sort macro based on cell changes within a range. The code works fine when manually changing these cells. However, the values in this range are typically updated by clicking a spin button (Active X).

Unfortunately, the existing code does not auto sort when the cells are updated in this manner.

Here is the code I use in the worksheet... I got a tip on another forum that I may need to change the even to Calculate, instead of Change. But when I make that change I receive a compile error.

Please Login or Register  to view this content.

... and the code for the macro

Please Login or Register  to view this content.

Any suggestions on getting the auto sort macro to run when the Spin Button updates these values? I should probably mention that the spin button is on a different worksheet.

Gave it a try and it does not produce errors, but it does not sort the desired range upon spin button click.

What does this part of the code you provided refer to? (I know I had that in my code but had borrowed that from another thread, so I'm not sure it is accurate)

.Range("B4"),

Aha! Actually your code was working fine, I just had to adjust the range up one row to account for a header. Thank you!!