Changing Color of Cell in VB

[Marian]

I am using VB and I am trying to change the color of a
cell (not necessarily the active cell). I am looping
through each task and setting the Task10 field and would
like to change the color of the text entry to red, green,
etc.

I know how to change the Gantt bars (thanks Jack!) but I
really want to simulate accessing the font menu and
changing the colors.

Any thoughts would be appreciated. Thanks.

Marian

 

[Mike Glen]

Hi Marian,

On the msnews.microsoft.com server, try the microsoft.public.project.vba
newsgroup as you are more likely to get an answer there.

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

 

[Jan De Messemaeker]

Hi Marian,

The application.font method works on the active cell(s)
I'm afraid you have to select the cell(s) before applying Font
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620