Forum Discussion
Solved
Disabling and re enabling Spinners controls in 2010 and setting the count back to zero.
Hi all, I am novice with anything to do with excel, most self taught. Right my question is, can a a non Active X control spinner be disabled and then reactivated and the count reset to zero. I a...
See the attached version. It is now a macro-enabled workbook, so you'll have to allow macros when you open it.
To inspect the code, right-click the sheet tab and select 'View Code' from the context menu.
Just checking, When I started a new file, I copied the code from above and changed the + to -, and setup the other parts for colour formatting and added a spin button, did I miss a step as code does not stop the up count when on N/A like does in the above file bbtest1-2.xlsm.
Was there another step I should have done.
Cheers.
Was there another step I should have done.
Cheers.
I'd have to see the workbook...
- Turns out that your first code was right, as when I put it back to that in my new version all started to work, as the first spinner starts at number is 2.