S
SteveT
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,
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,