Rotating group of shapes in excel VBA

I did use the solution in a thread by Andy to make a picture or shape rotate. It works perfectly as a standalone. With this I mean all the information on the same sheet as per example in the file 901259.

I'am using it to rotate a dial.
The problem is instead of using the value from the sheet itself I link the scrollbar to a cell on a different sheet in the same workbook. There some calculations are done and the value which makes the dial rotate is linked to that sheet. The dial however is on another sheet.

The calculations are almost displayed realtime but the dial is lagging. How would I go about to "solve" this lagging.

The slider (ScrollBar1) is an active X control on Sheet1. I configured the Scrollbar now to sent the value to eg cell M3 on Sheet1 and use the formula =ROTATE_SHAPE( "Sheet1";"Group 11";-M3). Furthermore I did expand Sheet1 to the left since the Group 11 box hit the border of Sheet1 and I thought it might hinder the rotation.

The dial is spinning in real time now.

I want to sent the value of ScrollBar1 to a sheet called "DATA". In the property of the ScrollBar1 I linked to cell DATA!I1. DATA is the sheet where the calculations are done. From DATA the value's are sent to various cells on Sheet1 to be displayed. The value to make the dial spin is also sent to this sheet and changes the reference from M3 to a reference on DATA.

This is when the dial starts lagging behind.

The problem therefore I suppose is in sending the data back and forth between the 2 sheets. Actually I should have a parallel output from the ScrollBar1.

Any suggestions?

The example is according to your given example. Scrollbar1 is linked to cell M3 and makes the dial spin I want it.

Thank you Andy.

Of all the possibilities I didn't figure this linked cell reference.

Your correct the group 12 in non existing. I did remove it but will be there in the final version. It is a second dial with an arrow rotating around the circumference of the dial and pointing out the direction the wind is coming from.

I will mark this succesfully solved