| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll bar increments select case?
I'm trying to change the increments of a scrollbar using select case,
but I can't quite get it, I'm sure its not too tough. Anybody have any advice? Sub ScrollBar3_Scroll() Select Case Range("AJ7").Value Case 101 To 199 ScrollBar3.SmallChange = 1 Case 200 To 298 ScrollBar3.SmallChange = 2 Case 300 To 395 ScrollBar3.SmallChange = 5 Case 400 To 590 ScrollBar3.SmallChange = 10 Case 600 To 980 ScrollBar3.SmallChange = 20 End Select End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| How do i set the scroll bar for increments of 0.5? | Excel Worksheet Functions | |||
| Select case | Excel Programming | |||
| Forms - Scroll Bar or Spinner (Data in increments) | Excel Discussion (Misc queries) | |||
Threaded Mode
