Select pivotfield item, not overwrite

[Glory]

Is there a way to select an item from a pivotfield instead of overwriting it?

This code just pastes the new value inserted into the combobox over the pivotfield value, even if the new value is not in the list.

ActiveSheet.PivotTables("Pivot Name").PivotFields("Field Name").CurrentPage = “Text”

 

[sijpie]

Well that is because you are saying it is something (in this case 'text')
If you don't know what the names are (ie the user can change the field names) then you can extract them from the datasheet i presume.

 

[Glory]

Well that is because you are saying it is something (in this case 'text')

Is there a way to select an item from a pivotfield instead of overwriting it?

...Does anyone else care to weigh in on this?