How to Add Shape "LeftRightArrow", "Rectangle" & "Diamond" using Dates as Reference

**AJPuy** · 04-23-2020, 08:56 PM

Good day everyone,

I am new in this forum an I have few and basic knowledge in vba code however, this is a hard time for me create a code on how to add the following shapes such as msoLeftRightArrow, msoRectangle and msoDiamond, considering I have some dates in Columns C & D and also date in Row 10 as a reference to the dates in Column C & D.

What I want is if I enter the Start & Finish dates in Column C & D respectively is should add or draw the above shapes as shown in the below image and attachment:

Attachment 674171

Many thanks in advance.

Regards,

AJ

**AJPuy** · 04-23-2020, 10:56 PM

I really need your help, because I am doing this manually for all the projects that I was involved. It took me a lot of time to complete but with macro I believe in just one click all works gets done. I am willing to pay or donate some amount just to have this code works! Please PM me, I don't know anybody who can do code this for me.

Thank you.

**Pepe Le Mokko** · 04-24-2020, 02:41 AM

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only two hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

If it is very urgent you can contact our Commercial Services

Please do not ask members to contact you via PM to solve the problems. As you probably have read our rules, abusing PM is not allowed. All posts pertaining to threads should be posted on the board for the benefit of all

How to Add Shape "LeftRightArrow", "Rectangle" & "Diamond" using Dates as Reference

LinkBack

Thread Tools

Rate This Thread

Display

How to Add Shape "LeftRightArrow", "Rectangle" & "Diamond" using Dates as Reference

Re: How to Add Shape "LeftRightArrow", "Rectangle" & "Diamond" using Dates as Reference

Re: How to Add Shape "LeftRightArrow", "Rectangle" & "Diamond" using Dates as Reference

Thread Information

Users Browsing this Thread

Similar Threads

Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

Using "index", "match", "min", "abs", to find the closest value in multiple criteria

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

= EMBED("Forms.ComboBox.1","") error "Reference not valid."

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] How to USE """"" cells count """"" change font color

Formula returning result of "True" or "False" instead of "1" or "0"

Bookmarks

Bookmarks

Posting Permissions