Hello Forum Guru's

I have a bunch of shapes that rotate and shift location due to a Common named Range

This Named range literally allows two moving shapes stay connected.
I have one cell that I input a Degree as a 0-360 value
the second shape is located Via VBA after Vlookup finds the corresponding figures.
It takes the Value 0-360 and converts that to three usable figures
Position X , Position Y , and Rotation.

What I need to do is manually align the shape first, Press the Display Button to get my figures which are the sixth decimal point accurate.

(which are then populated into Cells) and then Be able to Set those values into the Named Range via another button ...

Step 1. Align your image to where you want
Step 2. Get your X,Y,Rotation values into cells on worksheet 1
Step 3. Take the values and populate SHEET 2 with the figures
A. The Selection in Sheet2 is depending on what starting value is picked
Step 4. Test the Sheet 1 image location, by changing the degree of the whole project.
A. The image positions are recorded in 720 Frames (im calling the degree's)
If one frame is visually out of synch, I want a button to Set the new position, which updates the Named Range I currently use as a table reference for the path of the shapes.


I hope that was understandable. Im stuck with a simple coding similar to this ?
Please Login or Register  to view this content.
Thanks in advance,,,