View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skyhouse71 Skyhouse71 is offline
external usenet poster
 
Posts: 2
Default How do you define SpinButtons??

I have used the control toolbox to create a series of radio buttons. For one
of the radio buttons, when i click on it I want it to creat an OLEobject. I
created a privet sub program like the one below:

Private Sub Warrior_Click()

ActiveSheet.OLEObjects.Add(ClassType:="Forms.SpinB utton.1", Link:=False, _
DisplayAsIcon:=False, Left:=601.5, Top:=282, Width:=27, Height _
:=11.25).Select

End Sub

When I use the radio button it goes ahead and makes this spinbutton,
however, the spinbutton gets set to the default name "SpinButton1" and also
the defalt Max which is 100. I would like to create the spinbutton and set
the name and max number to what I want. How do you do this? Is it possible?