Move a Shape within an Excel Worksheet based on Input Data
<p>I'm looking at making a timeline within Excel that moves a 'window' (the white oval) along the timeline based on the date. 
<a href="https://i.stack.imgur.com/U01c2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U01c2.png" alt="enter image description here"></a></p>

<p>What I'm looking at doing is in VBA:</p>

<ol>
<li>Setting a scale (where the whole arrow is a year)</li>
<li>Setting the oval's initial position</li>
<li>Setting the oval's new position (based on how far down the timeline the date is)</li>
</ol>

<p>I'm completely new to VBA and was wondering if someone could please point me in the right direction?</p>

<p>Thanks!</p>