通过

Application.SelectResourceCell Method

  • 项目
Project Developer Reference

Selects a cell containing resource information.

Syntax

expression.SelectResourceCell(Row, Column, RowRelative)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Row Optional Long The row number (RowRelative is False) or the relative row position (RowRelative is True) of the cell to select.
Column Optional String The field name of the cell to select.
RowRelative Optional Boolean True if the row number is relative to the active cell. The default value is True.

Return Value
Boolean

Remarks

Using the SelectResourceCell method without specifying any arguments retains the current cell as the active cell. The SelectResourceCell method is only available when the Resource Sheet or Resource Usage view is the active view.

Example
The following example selects the third row in the Name column of the Resource Sheet.

Visual Basic for Applications 
  Sub Select_ResourceCell()

ViewApply Name:="&Resource Sheet"
SelectResourceCell Row:=3, Column:="Name", RowRelative:=False



End Sub

See Also