Click a Spin Button via another button?

I have a userform that has a Spin Button in it, and I am trying to hit a Command Button (or Label in this case) and make it run the SpinDown and then Another to run the SpinUp, but this doesn't appear to work.

Is this not possible?

My Spin Buttons look like this:

Please Login or Register  to view this content.

I tried this:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thanks in advance for any help.

(Of you need the reasoning behind this, it is so I can use better visuals for my Spin buttons than the default ugly ones)

There are no stupid questions for me...I am a complete newb with no training so I am learning as I go..I don't even know how to do what you suggest.

My buttons are all in a userform though so I don't know how to assign macros (thought that was only done when buttons were in the excel document)


The SpinButton codes above work on their own when clicking the actual spin button. I just want to click a separate button and it do the same thing as if I had clicked the spin button..if that makes sense.

I will attach form so it makes more sense you'll see the working spin button and the 2 labels I tried to use instead.

As the code stands at the moment you would need to modify the label click routines

Please Login or Register  to view this content.

Perhaps a cleaner way would be to remove the spinup and spindown routines and use the change event instead.

Please Login or Register  to view this content.

Andy thanks for your reply. Caught me right before going off to bed. I will try tomorrow and let you know how it works out. Much appreciated.

Edit:

I went ahead and tried, first one works perfect. The second I wasn't sure what to remove. There are several calls in the module for SpinButton and they are required for the other buttons to work so for now I went with the first option.

However cleaner is better so I'd like to figure out how to make the other option work.