Two Controls with One Linked Cell

[elotromateo]

I have two ActiveX controls (scrollbars), both connected to the same linked cell. One (Win) is in the same sheet as the cell, the other (Sum) is in a separate sheet. The problem is, whenever one bar is changed, I end up looking at the wrong screen. I tried having the final instruction be to go to the other sheet, since it should run through its code first and then look at the other one's code since it's value changed, but this just made it end on one sheet always.

It think the problem is that it runs the Sum scroll bar first, regardless of which was clicked first. Is there any way to force it to run it's own code before the other's?

Private Sub ScrollBarWin_Change()
'Code Here
Sheets("Summer Graphs").Select
End Sub

Private Sub ScrollBarSum_Change()
'Code Here
Sheets("Winter Graphs").Select
End Sub

 

[elotromateo]

Bump

 

[Arcticwarrio]

put them on seperate link cells then

 

[elotromateo]

I can't do that since the linked cell is referenced in a data sheet. Both scroll bars need to be able to manipulate this data. Regardless I think I just figured it out, I split the code between both controls and it seems to be working fine now, even if I don't really understand how that worked. Thanks for the help though.