spin buttons

I made a spin button linked to a cell with a Max of 100 and Min of -100, and a small change of 1, however, when I go below 0 the number turns to 65,535 and does not go negative at all. I need it to go down from 0 to -1, to -2, and so on. Does anyone know how to fix this?

Hi Leith - I saw your post to svay re; negative numbers using the spin button when modelling out scenarios

I copy pasted it for my own records .. thanks

I have 2 questions for you ...

to "get this working" .. do I
1) right click the tab on the worksheet and then scroll up to "view Code" ??
2) then copy paste in there ?

and the 2nd question I have for you is .. does this AUTOMATICALLY appy to ALL spin buttons within that tab within the worksheet ?.. what I mean is I have a NUMBER of spin buttons that I would like to have go into the negative values ... in fact 14 on one page/tab ... how would I go about permitting the negative values on each spin button ?


Thanks for your help in this complex question

atlus

Hello atlus,

You should have started a new thread and refernced this post in the new thread. To learn more about how to post, please click on this link Forum Rules.

You situation and the original poster's don't appear to be the same. Can you explain more about how this Spinners are used on the worksheet? What range of numbers are they using?

Sincerely,
Leith Ross