VBA to Rotate image incrementally based on cell values

I'm looking for some guidance for the vba code to use that will incrementally rotate an image based on values entered within a cell of an Excel spreadsheet.

I have two graphics, one is the face of a dial and the other is the pointer very much like a speedometer. I can achieve the desired outcome using two excel charts, one overlaid on top of the other, but, this doesn't give me the visual effect I'm looking for. please can you help.

I'm using the face of the semicircle dial as the background image and I have a separate image for the pointer. When a value between 1 and 100 is entered in cell O3 i would like the pointer to rotate to that position on the dial. The pointer is to have a fixed position and arc left to right where the value of 1 is left-most and horizontally aligned, and for the value 100 the pointer would point in the opposite direction. Any help would be gratefully received.

Thank you,

Steve Gilbert

Jakob, thanks for taking the time to reply. I've opened the spreadsheet and can see the code behind the Developer tab but i can't get the arrow to move when the value in O3 manually changes. I'me using Excel 2010. Any thoughts?

I've uploaded a file with the dial background and pointer.

Best wishes,
Steve

Yes please I'd be interested in getting the indicator to work. I can then find a way to rotate it via the hinge.

Thanks again.

Best wishes,
Steve

Yes please I'd be interested in getting the indicator to work. I can then find a way to rotate it via the hinge.

Thanks again.

Best wishes,
Steve

Originally Posted by Jakobshavn

Checkout the coding and performance of the attached



By changing the j-loop things can be slowed down or sped up

I cannot make this work. Why?

thanks. That worked. This is rather cool.

Andy, this is fantastic thank you very much. A quick question. . . . how would I change the scale so that the value of the dial starts at 0 and ends at 100 instead of 180?

Best wishes,
Steve

Andy, Absolute star. Thank you very much.

Best wishes,
Steve

Nicely done. Simple, direct, effective. I saw another posting on another site that had very complex trigonometry formulas and such. I'm sure they were correct but couldn't understand it.