Display Predecessor and Successor Task Names

[tdbcalif]

I want to display for each task row any predecessor and successor task names
that the task has.
I want to do this because the procject is relatively large.
I think I should use a customized text field. However, I am unsure how to
code the formula to pull the task name.
Any advice would be appreciated.
Thanks

 

[Mike Glen]

Hi tdbcalif ,

Welcome to this Microsoft Project newsgroup

From the Gantt Chart view, Window/Split. Click on any task in the top
window and its details are shown in the bottom screen. If you right click
in the bottom window, you can select Predecessors and Successors, which will
show you what you're after.

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on )

Mike Glen
MS Project MVP

wrote:

 

[JackD]

Since the text fields are limited to 256 characters it is quite possible you
will run out of room. The way to do this is not to use a formula. A formula
can only get information about the task itself so it can't get the
predecessor task name.

You will have to use VBA The following code will write predecessor task
names into the text1 field and successor task names into text2

Sub predsuccnames()
Dim t, p, s As Task
Dim ts As Tasks
Set ts = ActiveProject.Tasks
For Each t In ts
For Each p In t.Predecessors
t.Text1 = t.Text1 & p.Name & ", "
Next p
For Each s In t.Successors
t.Text2 = t.Text2 & s.Name & ", "
Next s
Next t
End If
End Sub

 

[JulieD]

Hi
one method i use when the blue lines just get all too confusing is to format
the gantt bar chart to show the predecessor numbers on the left and the
successor numbers on the right (format / bar styles - text tab) and then i
turn off the arrows (format / layout). It's a bit of a pain having to hunt
for the predecessors / successors by number but it's a lot easier than
trying to follow the lines!

Cheers
JulieD

 

[agelasttsa4924]

silver bracelets are believed like a precious jewelry item

Just after working out these regulations with your intelleDt, you may now disDover the DorreDt immobilier available for you through qualified real estate property brokers, print ads and on-line information and faDts BeDause sharing of information is now Dreated less diffiDult, make great utilization of it by exploring from eaDh one of these platforms jennabridalshop com/]cheap wedding dresses
have the most effeDtive disDounts all over When you have a preferenDe for freshly DonstruDted qualities, you are able to look at whenever they have warranties or whether or not the DontraDtor is affiliated with respeDted Dompanies It is aDtually aDDurate whiDh the vitality and Dommand of gold and platinum in jewelry is around Good preDeding silver fashion jewellery is steadily growing ground and is thought of now an likewise exDellent alternative in ornamentjennabridalshop com/]cheap wedding dresses
These days, it truly is Donsidered to be jennabridalshop com/]cheap wedding dresses
be stylish sporting silver trend jewellery and its vogue is in
|