• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

Setting up MS Project Text Forecolor

Hi ,

I would like to set up font and color for every row or task on MS Project using VB.
MS Project allows to set up font and color only if we select the required row, which I am trying to using VB code.

My problem is when  I use .SelectRow method and specify dynamic row number, it does not select specified row but it goes way to below specified row.

Can somebody help me on this?

  • 2
  • 2
1 Solution
Do you explicitly specify False for the second parm?

If not, the selection is relative to the active current row.
amiteshsinhaAuthor Commented:
Thanks a lot for your reply.

You are right, I have specified "True" for seconf parameter. But still it skips few rows below.
Here i sthe parameter list for .SELECTROW method.

SelectRow(Row, RowRelative, Height, Extend, Add)

For first parameter "ROW" , I am specifying a dynamic variable, which is "i".
This is same as my TASK ID which helps me to sep up TASK Name. While entering TASK Name it does not skip any rows , it set text one after another line.

For Second Parameter "RowRelative" , I am passing "TRUE" Value

Here is the actual call for .SELECTROW method.

projApp.SelectRow i, True, 0, False, False

projapp is "Project Application Object"

Do you think anything going wrong here.

Thanks in advance.

If you want to go to row 'i', set the second parameter to false.
amiteshsinhaAuthor Commented:
Thanks for your reply.
It is working. Great help, tried many ways to fix this but never thought this way.
Thanks a lot.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now