Setting an angle

Hey everyone

Okay so I have a program that rotates an arrow when a button is pushed. I use this code

Please Login or Register  to view this content.

This works fine, however i want the image to be back to normal every time the program is opened. I cant just say "When the worksheet is opened rotate it -50" because the "50" will be a random variable.

Hi,

you could create a cell that stores the changes made to the rotation, so when its rotated by 50 add 50 in the cell, if its then rotated -70 add -70 to the cell leaving -20 in the cell,

then when the workbooks open, rotate by - this cell, and reset the cell to 0.

Regards,

Andy