Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the SpinButton value in Workbook_Open()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substitute for OLE SpinButton? | Excel Discussion (Misc queries) | |||
Spinbutton | New Users to Excel | |||
Spinbutton | Excel Discussion (Misc queries) | |||
spinbutton? | Excel Programming | |||
SpinButton Rounding Up | Excel Programming |