View Single Post
 
Old 03-30-2015, 01:23 PM
jjmclell jjmclell is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2012
Location: Sault Ste. Marie, Canada
Posts: 52
jjmclell is on a distinguished road
Default

Here's a quick macro I wrote that sets the value of the Text1 field for any given task to the value in the Name field for the preceding task (ignoring the first task that has no preceding task). Very simple, but you can see how this sort of thing is possible. You can then just assign the macro to a button and click it anytime you want to update...

Code:
Sub setFieldText()
    Dim temp As Long
    For temp = 2 To ActiveProject.Tasks.Count
        ActiveProject.Tasks(temp).Text1 = ActiveProject.Tasks(temp - 1).Name
    Next temp
End Sub
Attached Images
File Type: png settextfieldmacro.PNG (13.9 KB, 10 views)
Reply With Quote