Changing the properties of controls on a worksheet is slightly different
from changing controls on an UserForm.

The main difference is the way controls should be called.

I assume you have two "Spinners" in Sheet1.
See the macro below.

Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("Sheet1")
.DrawingObjects("Spinner 1").Value = 10
.DrawingObjects("Spinner 2").Value = 100
End With
End Sub

"DrawingObjects" is a very safe way to refer to controls on a worksheet. All
controls can be referred to as DrawingObjects.


Regards,
Edwin Tam
edwintam@vonixx.com
http://www.vonixx.com



On 1/15/05 1:08 PM, in article
c0e1827f.0501142108.353ea4e5@posting.google.com, "Tony Steane"
<tsteane@hotmail.com> wrote:

> Greetings One and All,
>
> I have two SpinButtons on a worksheet and I am trying to change the
> value of each button as I open the Workbook. Each button will have
> a different value assigned.
>
> I have tried the obvious :
>
> Private Sub Workbook_Open()
>
> Spinbotton1.value = 10
> Spinbutton2.value = 24 both are random numbers each time.
>
> end sub
>
> However I recieve the error "didn't provide a valid object qualifier".
>
> My knowledge is such that I am unable to find out how this is done.
>
> Would somebody please provide me with a solution and if possible a web
> site where this topic is discussed. ( in simple terms if possible.)
>
> Cheers
>
> Tony