Table of contents
Collapse the table of content
Expand the table of content

Cell.Task Property (Project)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Gets a Task object representing the task in the active cell. Read-only Task.


expression. Task

expression A variable that represents a Cell object.


The following example displays the names of all tasks at the same outline level as the selected task.

Sub Siblings() 

 Dim MyParent As Task 
 Dim Sibling As Task 
 Dim Temp As String 

 Set MyParent = ActiveCell.Task.OutlineParent 

 For Each Sibling In MyParent.OutlineChildren 
 Temp = Sibling.Name &; ListSeparator &; " " &; Temp 
 Next Sibling 

 Temp = Left$(Temp, Len(Temp) - Len(ListSeparator &; " ")) 
 MsgBox Temp 

End Sub
© 2017 Microsoft