MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Spin button upsidedown is it possible?


Posted by Sandy on January 23, 2002 9:54 PM

How can I make a spinbutton to count up while clicking the top part and down when clicking the bottum part.


Posted by Tom Dickinson on January 23, 2002 11:57 PM

2 macros: SpinUp as one, and SpinDown as the other (NT)

Posted by Terry on January 24, 2002 9:08 AM

I am not sure what you mean, but if you change the upper and lower bounds of the SpinButtons properties you should be able to spin up/down to those limits and the lower bounds can be negative if you want. Remember you need a one line VBA code or must associate the spinbutton value to a cell in order to display the numbers