Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a ScrollBar control and linked it to a cell. I also want the min
and max properties linked to a cell. I know this is not directly possible, so I'm trying to write a Worksheet_Change event that updates the properties when the specified cells change. I can't figure out how to correctly set the scrollbar to an object that gives me access to the Min and Max property. The control is of the type MSForms.ScrollBar, but I can only figure out how to refer to it as a Shape or a OLEObject, neither of which allow me to set the max or min properties. Can anyone advise further? Thanks, Pflugs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
How to modify fill handle properties? | Excel Discussion (Misc queries) | |||
Modify File Creation date in VBA using Document properties | Excel Programming | |||
How to modify fill handle properties? | Excel Discussion (Misc queries) | |||
Label Scroll Bar Properties: Make Visible? | Excel Programming |