Reply to thread

Message: [QUOTE="SteveT, post: 13227849"] Hello, I have a template sheet that uses cell "M1" value as the row match within index functions throughout the sheet. I'd like to use a scrollbar to allow users to change the "M1" value using the scroll bar in turn changing results of the index function while staying within perimeters of cell "M2" (The Minimum) AND cell "M3" (The Maximum). These variables (MIN & MAX levels) will change each time template document is entered by user, requiring the MIN & MAX settings of scrollbar to reset to the "M2" and "M3" values I believe this can be accomplished from the limited amount of info browsed through on web using event macro but I've had no success sorting through myself. Any Help would be greatly appreciated. Thanks, [/QUOTE]