Task Name as a drop down field.

[Mit]

Hi,
I need to set up a template. I need to have the task name field as a drop
down list box and have the values to choose from. Depending on what is being
chosen , I need to autopopulate the duration field and resource field.
1) Is there a way to do it without VBA
2) If I have to use VBA, can anyone point me to resources which has examples
of codes.

Thanks,

 

[Rod Gill]

Hi,

No! Duration and resource fields cannot be changed by formulae, so VBA is
all you can use.

In VBA I suggest you set up Task data etc in a Text file that is read by
your VBA macro. This is much easier to maintain and update than a long
lookup list that has a finite number of entries (can't remember the limit).

There are some VBA resources in http://project.mvps.org/vbacode.htm and
Microsoft's MSDN site. Alternatively I have published the only book on
Project VBA, see: http://www.projectvbabook.com

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com