![]() |
#3
|
|||
|
|||
![]()
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 |
Tags |
field, function |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Retrieving data from data base based on text selection | capitala | PowerPoint | 0 | 12-10-2014 08:10 AM |
How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |