Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Name | Excel Worksheet Functions | |||
Name Define | Excel Discussion (Misc queries) | |||
Define name Q | Excel Discussion (Misc queries) | |||
define name | Excel Discussion (Misc queries) | |||
Name define | Excel Programming |