Microsoft project vba tutorial how to#
Microsoft project vba tutorial code#

Up pops the Microsoft Project VBA developer tools. Next select the newly appearing Developer tab and click Visual Basic, Figure 4. Toggle Developer in the Main Tabs customize the ribbon options, Figure 3. Proceed by right clicking and selecting вЂCustomize the RibbonвЂ¦вЂќ in the resulting popup menu, Figure 2. To start we first add the developer tab, so that we have access to Microsoft Project VBA tools. WouldnвЂ™t it be nice to have a column that separates out the material cost of each task and the entire project? Yes, it would, and to do this in Microsoft Project weвЂ™ll need the VBA Project developer. The Cost column displays the cost of both labor and material for each task and the entire project. Note in the вЂResource NamesвЂ™ column that both labor and material resources have been applied to respective tasks. This schedule already has been updated with one weekвЂ™s progress. In Figure 1 we have a Pipe Repair & Improve project.

Microsoft project vba tutorial code#

Thanks to the VBA Project community I was able to obtain the code for this demonstration. The intent is to get you started in applying Project VBA subroutines to solve a real life limitation in Microsoft Project. I did not write the subroutine nor have I fully tested all applications of the subroutine with Microsoft Project. The VBA material cost subroutine demonstrated in this blog comes from my inquiry on a Project VBA forum. CautionДЄ word of warning before we get started.

Microsoft project vba tutorial how to#

This article builds on your understanding of Microsoft Project custom fields to explain how to get started with Microsoft Project VBA programming. Microsoft Project comes standard with VBA program development tools. Great! So applying a basic knowledge of custom fields and Project VBA programming will enable us to create a custom field for displaying the material costs of tasks. Refer to the blog Using Microsoft Project Custom Fields for an introduction to custom fields. In addition to the Project VBA basics creating a material cost field also requires a rudimentary understanding of Microsoft Project custom fields. I was even recommended the following VBA Project programming book вЂњVBA Programming for Microsoft Project вЂ™98 through 2010 with an introduction to VSTOвЂќ by Rod Gill. Well, by consulting a Microsoft Project discussion forum I quickly found the required VBA subroutine for listing task material cost. But knowing how to program Project VBAs, apparently, opens the door to a myriad of project data in Microsoft Project. I donвЂ™t intend to validate the accuracy of my brother-in-lawвЂ™s theory. My question is why would project data as simple as listing the material cost require a VBA subroutine extension? My brother-in-law, a computer science professor, surmises that Microsoft, most likely, intentionally left out the material cost field to nudge all us novice Microsoft Project users towards programming Project VBAs. Apparently, displaying this project data requires the insertion of a Visual Basic Application (VBA) subroutine for Microsoft Project. I was somewhat surprised to discover that the standard Microsoft Project installation does not have a variable or field for displaying the resource material cost of tasks.