VBA Help need for creating Gantt Chart by using text boxes

Hi Folks,

I have a workbook with two sheets, one for data input sheet and another one for Gantt Chart. I would like to auto set the baseline and progress bars (Text Boxes) based on the date, time and percentage completion in the Gantt chart sheet by using VBA codes. I have attached a file of what I'm trying to accomplish.

Thanks in advance for your expertise!

Joshi