Task Name Column - List Values

F

Fabio Kozamekinas

How can I create a List of predefined values in the Task Name Column like
Text1, Text2, Cust1, Cust2 ....
I need to create a combobox in this field with any predefined values.

Is this possible?

Thanks in advanced

Fabio Kozamekinas
 
J

Jan De Messemaeker

Hi,

You can only cretae listboxes in a custom field, not in the name field.
Solutions may be:
- Create the listbox in a custom text field and copy the text field into the
name field;
- Or use a real combo box in VBA to populate the name field in a VBA
procedure.
HTH
 
F

Fabio Kozamekinas

Thanks for the answer, but .. how is the best way to copy the text field to
name field? Every time the user fill the text field the name field need to be
filled automatic.

Do you have a sample of How can I create a combobox field in VB and use this
in the MS Project, populating que name field?

Thanks a lot

Fabio Kozamekinas


"Jan De Messemaeker" escreveu:
 
J

Jan De Messemaeker

Hi,

I didn't day VB, I said VBA which is moe integrated with Project
In Project, go Alt+F11 to see trhe VB Editor

Yo have the toold to create a form with a combo box
I suppose the logic to populate it (.additem) is not different from VB
The form will have an OK button that hides the form

In a module you write a sub like this

Sub FillNameCol()

for each anytask in activeselection.tasks
if not anytask is nothing then
Mycomboform.show
'The code of he combobox takes over
'You re-enter here when the forms is hidden
anytask.name=mycomboform.mycombo.value
end if
next anytask

end sub



This should get you started.
Greetings,
 
F

Fabio Kozamekinas

I am trying to do this but .... no success.

I´m begginer using VB or VBA, could you please send me a email with a
File.MPP with the solution proposed?

(e-mail address removed)

Thanks


"Jan De Messemaeker" escreveu:
 
F

Fabio Kozamekinas

Hi Jan ... thanks for you help. Now I need to solve another doubt.
The code in the file is exactly what I need to do .. but I must to know how
to start the macro in the lose focos or on focus event for sample in the
TextX Field.

Is this possible?

Thanks in advanced.

Fabio




"Jan De Messemaeker" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top