Web Development

Ask something
Discussion Locked

MS Project 2003 VBA

0 helpful
2 replies

by sunnikost

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need coding that will populate a text field with the word 'Note' when the activity is 100% complete or if it is a 'summary' type activity. Also must have the ability to enter the word 'Note' manually when necessary. Thanking you in advance - Jay

2 replies

by robert - project mgr

This does not need any VBA.
Right Click in task col heading and choose customise field enter T and select any text field
Select the formula radio button and enter
IIf([% Complete]=100 or flag1,"Note","")
Setting flag1 (your manual need) to yes will result in the text field containing the text "Note"

by sunnikost

MS Project Standard 2003 (Stand Alone Mode) - How can I prevent "Not Responding" from appearing in the header bar when I run my code module. Once this happens I can't do a thing but close the file and open it again in order to work on the file. Thank you

This discussion is closed to new replies.