Many Thanks to each of you for your assistance.

In this case, it was as Bob suggested that:

If you use the one from the control toolbox, you can use
activesheet.oleobjects("SpinButton1").object.value =10

It seems that when asking any question you really have to be precise. As
in this case a "spin button" has two meanings.

Ever again I will continue to try to work through this maze they call
Excel :-)

Cheers and Thanks

Tony

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!