Field Formula?

[devbro]

Hi

I have created a drop-down menu using a custom text field and wish to
enter a date into Baseline Finish based on the users selection. For
example; if the user selects J350 from the drop-down, it enters 1/20/07
in the Baseline Finish. There are roughly 20 possibilities the user
could select so it would be nice if I could centrally store a simple
matrix or look-up table that Project could pull from.

As a side note, the drop-down selections represent the assembly cost
center and the Baseline Finish is the assembly load date. The reason
the load date is the Baseline Finish is because I’m scheduling from the
Project end date backward to schedule all events necessary to design and
fabricate parts for assembly. The load dates change periodically and I
need a way to ensure consistency and accuracy across schedules.

VB, Macro, Formula….????????

 

[Rod Gill]

Hi,

Formulae can only live in custom fields so all other fields, including all
baseline fields need to be set manually or by VBA.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[devbro]

Thanks Rod,

How would I do this with VBA

 

[Rod Gill]

Without a proper design, teh answer is can't know! You are scheduling Just
in time so be aware that this makes all tasks critical, so a delay in one
task causes a delay in teh final finish date - Risky!

You need a way of importing the dates and storing them, then looking them up
based on the value in the Custom text field. There are a number of ways to
do this, the best, easiest and quickest way will depend on what information
you have, where it comes from, what format and more.



--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[devbro]

Rod,
......slick......!

Thanks