Prev: Correcting a typo in large value list
Next: Un-Provision Project Server Web Access
From: Jack Dahlgren MVP on 8 Mar 2010 16:42
Select first item by clicking. Scroll down. Hold shift key and click. The
entire set of items between those two points will be selected.

-Jack

"Val" <Val(a)discussions.microsoft.com> wrote in message
news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
> How do I cut all 200 rows at once? I don't really want to do it one at a
> time.
>
> Thanks.
>
> "Jack Dahlgren MVP" wrote:
>
>> Yes. Select then click on the cut icon. Try it.
>>
>> -Jack Dahlgren
>>
>> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
>> > Is there a way to delete multiple rows in a value list for a Text
>> > column?
>> > I
>> > have over 200 rows out of a value list that are duplicates that I need
>> > to
>> > delete. I can delete them row by row but I'd like to click on the 1st
>> > row
>> > and shift click on the last row that needs to deleted. Is this
>> > possible?
>> >
>> > Thanks in advance (from a Project newbie)
>>
>> .
>>
From: Val on 8 Mar 2010 17:45
Tried that - it didn't work :(

I'm inside the value list dialog box so I'm thinking that is the problem.
Is there somewhere else that I can go to edit the value list?

thanks.

"Jack Dahlgren MVP" wrote:

> Select first item by clicking. Scroll down. Hold shift key and click. The
> entire set of items between those two points will be selected.
>
> -Jack
>
> "Val" <Val(a)discussions.microsoft.com> wrote in message
> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
> > How do I cut all 200 rows at once? I don't really want to do it one at a
> > time.
> >
> > Thanks.
> >
> > "Jack Dahlgren MVP" wrote:
> >
> >> Yes. Select then click on the cut icon. Try it.
> >>
> >> -Jack Dahlgren
> >>
> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
> >> > Is there a way to delete multiple rows in a value list for a Text
> >> > column?
> >> > I
> >> > have over 200 rows out of a value list that are duplicates that I need
> >> > to
> >> > delete. I can delete them row by row but I'd like to click on the 1st
> >> > row
> >> > and shift click on the last row that needs to deleted. Is this
> >> > possible?
> >> >
> >> > Thanks in advance (from a Project newbie)
> >>
> >> .
> >>
> .
>
From: Jack Dahlgren MVP on 8 Mar 2010 18:01
Which version of MS Project?
In Proj 2007 right-click a column header - select customize fields, then
click the lookup value button.


"Val" <Val(a)discussions.microsoft.com> wrote in message
news:B3D0D4CA-9891-44BD-BA85-BF16E0997AE4(a)microsoft.com...
> Tried that - it didn't work :(
>
> I'm inside the value list dialog box so I'm thinking that is the problem.
> Is there somewhere else that I can go to edit the value list?
>
> thanks.
>
> "Jack Dahlgren MVP" wrote:
>
>> Select first item by clicking. Scroll down. Hold shift key and click. The
>> entire set of items between those two points will be selected.
>>
>> -Jack
>>
>> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
>> > How do I cut all 200 rows at once? I don't really want to do it one at
>> > a
>> > time.
>> >
>> > Thanks.
>> >
>> > "Jack Dahlgren MVP" wrote:
>> >
>> >> Yes. Select then click on the cut icon. Try it.
>> >>
>> >> -Jack Dahlgren
>> >>
>> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
>> >> > Is there a way to delete multiple rows in a value list for a Text
>> >> > column?
>> >> > I
>> >> > have over 200 rows out of a value list that are duplicates that I
>> >> > need
>> >> > to
>> >> > delete. I can delete them row by row but I'd like to click on the
>> >> > 1st
>> >> > row
>> >> > and shift click on the last row that needs to deleted. Is this
>> >> > possible?
>> >> >
>> >> > Thanks in advance (from a Project newbie)
>> >>
>> >> .
>> >>
>> .
>>
From: G�rard Ducouret on 8 Mar 2010 18:35
Val,

Several years ago, with 2003 version, I used the following macro to fill a
value list with all the data copied in the Task field of Project 2003.
May be you could adapt it to your purpose.
G�rard Ducouret

Sub ListeD�roulante()

Dim oTache As Object
Dim Texto As String, Desc As String
'Call Chasse_Carac_interdits ' Chasse le "." interdit dans les noms car
utilis� comme s�parateur
SelectTaskColumn Column:="Texte10" 'on s�lectionne la colonne text10

For Each oTache In ActiveProject.Tasks 'pour chaque tache dans le
projet actif
If Not oTache Is Nothing Then 'si on a pas saut� de ligne
Texto = oTache.Name 'texto=le code (1�re colonne de
la liste)
Desc = oTache.Text1 'desc=colonne de description (la
2�me col.)
CustomFieldValueListAdd FieldID:=pjCustomTaskText10, Value:=Texto,
Description:=Desc
'la ligne ci dessus renseigne le champ "text10" avec la valeur dans
"texto" et dans "desc"
End If
Next oTache
CustomFieldValueList FieldID:=pjCustomTaskText10, ListDefault:=False,
RestrictToList:=True, DisplayOrder:=pjListOrderDefault
'pour le m�me champ personnalis� : renseigne quelques param�tres li�s � la
liste d�roulante
CustomFieldProperties FieldID:=pjCustomTaskText10,
Attribute:=pjFieldAttributeValueList, SummaryCalc:=pjCalcNone,
GraphicalIndicators:=False, Required:=False

End Sub

"Val" <Val(a)discussions.microsoft.com> a �crit dans le message de news:
DB62FD66-CD6C-4ED9-BAD2-1744CF702A08(a)microsoft.com...
>I copied the value list from another project but unfortunately another user
> did not restrict the values to this list and allowed the new values to be
> appended to the value list. I need to delete over 200 rows in the value
> list
> and then restrict the values to the remaining 200 rows.
>
> "G�rard Ducouret" wrote:
>
>> Hello Val,
>>
>> This value list was created in Project (desktop) or in PWA?
>>
>> G�rard Ducouret
>>
>> "Val" <Val(a)discussions.microsoft.com> a �crit dans le message de news:
>> 6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
>> > Is there a way to delete multiple rows in a value list for a Text
>> > column?
>> > I
>> > have over 200 rows out of a value list that are duplicates that I need
>> > to
>> > delete. I can delete them row by row but I'd like to click on the 1st
>> > row
>> > and shift click on the last row that needs to deleted. Is this
>> > possible?
>> >
>> > Thanks in advance (from a Project newbie)
>>
>>
>>
>> .
>>



From: Val on 9 Mar 2010 10:50
Project 2003
I right-click the column header - select customize fields, then select
value list. It appears that I can only cut/delete a row from the value list
one at a time. I'd like to delete 200 rows all at once instead of line by
line.



"Jack Dahlgren MVP" wrote:

> Which version of MS Project?
> In Proj 2007 right-click a column header - select customize fields, then
> click the lookup value button.
>
>
> "Val" <Val(a)discussions.microsoft.com> wrote in message
> news:B3D0D4CA-9891-44BD-BA85-BF16E0997AE4(a)microsoft.com...
> > Tried that - it didn't work :(
> >
> > I'm inside the value list dialog box so I'm thinking that is the problem.
> > Is there somewhere else that I can go to edit the value list?
> >
> > thanks.
> >
> > "Jack Dahlgren MVP" wrote:
> >
> >> Select first item by clicking. Scroll down. Hold shift key and click. The
> >> entire set of items between those two points will be selected.
> >>
> >> -Jack
> >>
> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
> >> > How do I cut all 200 rows at once? I don't really want to do it one at
> >> > a
> >> > time.
> >> >
> >> > Thanks.
> >> >
> >> > "Jack Dahlgren MVP" wrote:
> >> >
> >> >> Yes. Select then click on the cut icon. Try it.
> >> >>
> >> >> -Jack Dahlgren
> >> >>
> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
> >> >> > Is there a way to delete multiple rows in a value list for a Text
> >> >> > column?
> >> >> > I
> >> >> > have over 200 rows out of a value list that are duplicates that I
> >> >> > need
> >> >> > to
> >> >> > delete. I can delete them row by row but I'd like to click on the
> >> >> > 1st
> >> >> > row
> >> >> > and shift click on the last row that needs to deleted. Is this
> >> >> > possible?
> >> >> >
> >> >> > Thanks in advance (from a Project newbie)
> >> >>
> >> >> .
> >> >>
> >> .
> >>
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Correcting a typo in large value list
Next: Un-Provision Project Server Web Access