Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll Bar / Spin Button Small Change value
I'm using the following code for a scroll bar, straight from the help menu.
I need the small change value to be "0.5". In this instance it does not work. Any ideas why? regards Wayne Private Sub Workbook_Open() Set sb = Worksheets(1).Shapes.AddFormControl(xlScrollBar, _ Left:=10, Top:=10, Width:=10, Height:=200) With sb.ControlFormat .LinkedCell = "D1" .Max = 100 .Min = 0 .LargeChange = 10 .SmallChange = 0.5 End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll Bar / Spin Button Small Change value
If you check the Object Browser, you can see these properties of are longs,
hence no decimal part. If you need this, multiply all properies by 10, then divide by 10 before using the .Value. NickHK "PCH" wrote in message ... I'm using the following code for a scroll bar, straight from the help menu. I need the small change value to be "0.5". In this instance it does not work. Any ideas why? regards Wayne Private Sub Workbook_Open() Set sb = Worksheets(1).Shapes.AddFormControl(xlScrollBar, _ Left:=10, Top:=10, Width:=10, Height:=200) With sb.ControlFormat .LinkedCell = "D1" .Max = 100 .Min = 0 .LargeChange = 10 .SmallChange = 0.5 End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spin Button control change capture in ThisWorkbook Module | Excel Programming | |||
Spin Button | Excel Programming | |||
spin button value | Excel Discussion (Misc queries) | |||
Spin Button... | Excel Programming | |||
Spin Button | Excel Programming |