How to automatically move Line(Shapes) based on cells content?

Please see sample Sample.xlsm

Thanks!

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Please Login or Register  to view this content.

hmgrts,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.