Daniel has attended:
Excel Advanced course
Macro Gantt Chart
Hello,
I want to build a Gantt chart to show a project timeline. However, I want to make it available for the rest of the team to add tasks etc. Does anyone know how:
1) I am able to get the Gantt add in like I can see in some of the example charts I have seen?
2) How to create a 'form' people can fill out that then auto populates into the Gantt chart?
3) Any advice on a macro Gantt chart?
Thanks very much,
Dan
RE: Macro Gantt Chart
Hi Daniel,
Thank you for the forum question.
Excel can do everything (almost).
I do not know which add in you use, but you can create a gantt chart without a add in (please see link below)
https://www.ablebits.com/office-addins-blog/2014/05/23/make-gantt-chart-excel/
The input form can be done with VBA only. Macros cannot create forms. It is complicated and you need VBA knowledge. We are creating userforms on our VBA intermediate course.
I have found a video which can make you get started.
https://www.youtube.com/watch?v=5PN7lWJSobQ
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
