ActiveX Spin Button LinkedCell Question

Hello Everyone,

I am going nuts trying to chance the LinkedCell of my ActiveX spin button to reference a cell on another sheet. In other words, the spin button control is on sheet1 but the cell I want it to change and reference is on sheet2. I keep getting:"Run Time error 9 subscript out of range". Its strange because when I reference a cell on sheet1 where the control resides it works. Help!

Thanks for the help...

Moderator's note: Moved from Hello. Question indicates a VBA runtime error so off we go to VBA. --6StringJazzer