Excel Forms Spin Button - Return to 1 after max value

L

LarryK1

Joined
Jun 18, 2014
Messages
1
Reaction score
0
HI all,

I'm looking for a little help with the forms spin button please.

I have a spin button to incrementally select a week number (we are week 25 now and last week in December is week 52). It all works as it should however I would like it to nudge to week 1 after week 52 so that it continues on from there 2,3,4 and so on.

Is there a way to cycle round to the minimum value after the maximum value?

And from lowest number, back to highest?

Thanks,

Laurence
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spin button to scroll up&down a database with a userform 7
Spin Button 1
Controlling an ActiveX Spin Button 5
Trying to find additional ranges outside of min, max, and average 2
MAX in VBA not working 5
Set Increment on Spin Button to 0.1 1
Transfer Value to another sheet with Macro 12
How do I get Excel to make highest #, 1 color, & lowest # another? 1

Top