Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

Protected by reCAPTCHA: Privacy & Terms

MPUG - Master Project User GroupMPUG

If you’re using Project 2010 or Project 2013, use the following subroutine to display the formula in a custom field:

‘ © Ismet Kocaman
‘
Sub Show_Formula()
If Application.CustomFieldGetFormula(ActiveCell.FieldID) <> “” Then
MsgBox Title:=”Field: ” & ActiveCell.FieldName, Prompt:= _
Application.CustomFieldGetFormula(ActiveCell.FieldID)
Else
MsgBox Title:=”Field: ” & ActiveCell.FieldName, Prompt:= _
“No Formula”
End If
End Sub

To add this subroutine to a project plan file, follow these steps:

1. Open a blank mpp file and save it with a new name, such as “ShowFormula.mpp”.
2. Click Alt-F11 to open Visual Basic Editor.
3. Click VBAProject(ShowFormula.mpp) on the left and open the Insert menu from the menu bar.
4. Click Module to insert a module.
5. Click Module1 (or the module inserted) on the left, and copy the subroutine above and paste it into the Module1 window on the right.
6. Close Visual Basic Editor.

To add a button for the subroutine to the Quick Access Toolbar, do this:

1. Click the File tab and select Options to display the Project Options dialog box.
2. Click the Quick Access Toolbar and select Macros in the Choose commands from drop-down.
3. Select ShowFormula.mpp|Show_Formula on the left and click Add in order to add ShowFormula.mpp|Show_Formula to the command list in the Customize Quick Access Toolbar box on the right.
4. Use Modify to select any icon that you like and enter a display name for the subroutine.
5. Click OK to close the Project Options dialog box.

Now the icon for the subroutine will appear on the toolbar. Click a custom field containing a formula and then click the button for the Show_Formula to see how it works.

Ismet Kocaman custom field quick view

Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

Protected by reCAPTCHA: Privacy & Terms

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM GlossaryOur Faculty

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUGMaster Project User Group

© 2026 MPUG. All rights reserved.

TermsPrivacySitemapAdvertise
Articles

Get a Quick View of a Custom Field Formula

If you’re using Project 2010 or Project 2013, use the following subroutine to display the formula in a custom field: ‘ © Ismet Kocaman ‘ Sub Show_Formula() If Application.CustomFieldGetFormula(ActiveCell.FieldID) <> […]

2 min read
•about 11 years ago•Updated 10 months ago•
I
Ismet KocamanAuthor
Project Management
Microsoft Project
Best Practices
Productivity
I
Ismet Kocaman

Content Writer

Ismet Kocaman, MCTS, PMP, is a Mechanical Engineer and has more than 15 years of project management experience in the manufacturing sector. He currently provides consultancy to small to mid-sized companies on project management, reorganizing, and streamlining the manufacturing operations. He also conducts training seminars for engineers on MS Project. Contact Ismet at ikocaman.pm@gmail.com.

View all articles by Ismet Kocaman
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

Collaboration challenges in remote projects (and how to fix each one)
Articles
1 min read

Collaboration challenges in remote projects (and how to fix each one)

Discover 5 common remote project collaboration challenges, from knowledge silos to unclear ownership, and learn practical ways to keep teams aligned and work moving.

A
Anonymous
2 days ago
Read
An Introduction to the PMI Practice Standard for Scheduling Conformance Index
Articles
1 min read

An Introduction to the PMI Practice Standard for Scheduling Conformance Index

Learn how the Conformance Index in PMI’s Practice Standard for Scheduling scores a CPM schedule model, and how to assess its components in any scheduling tool.

A
Anonymous
13 days ago
Read
A PM’s Halloween Survival Guide: The Sequel You Didn’t Want but Definitely Need
Articles
1 min read

A PM’s Halloween Survival Guide: The Sequel You Didn’t Want but Definitely Need

Part II of the PM Halloween survival guide takes on shape-shifting requirements and dependencies that won’t stay resolved, with practical defenses for each.

A
Anonymous
about 1 month ago
Read
Explore All Articles