shg you are quite right. I'm not sure why I didn't get a syntax error when I ran it, but I definitely should have caught the fact that the cell was not updating correctly.

Nevertheless...Evalis, I downloaded your workbook and the reason that your macros aren't working is because you are using the wrong kind of spinner. There are two types of controls that you can put onto a worksheet: Forms Controls and ActiveX controls. You can go into Excel's help documentation for a pretty good explanation of the difference between the two.

I think there may be a non-VBA solution here. I'm going to take your workbook home and play with it for a bit, free of distraction, so that I don't post any more junk solutions for you. If someone comes up with a suitable fix for you in the meantime, then good on them. I will still post a solid solution for you to ease my karma after leading you in the wrong direction earlier.