View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pflugs Pflugs is offline
external usenet poster
 
Posts: 167
Default Modify Scroll Bar Control Properties

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