MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Form Controls


Posted by Mike on January 05, 2002 8:46 AM

Is it possible to access the properties of the form controls from VBA? I need to be able to change the min and max values of a form scrollbar control that resides on an imbedded chart programatically. I can't even figure out what it's name is.

Thanks...Mike


Posted by Ivan F Moala on January 06, 2002 1:23 AM

The Forms controls are part of the Activesheets
Shapes......so
something like this should get you it.

With ActiveSheet.Shapes("Scroll Bar 2").ControlFormat
.Min = 10
.Max = 150
End With

Ivan

Posted by Mike on January 06, 2002 3:46 PM

Ahh! Cool, thanks...Mike