Right, this is doin' ma box in and wondered if anyone may have come across
this before and have a solution.

I have a Combobox on a worksheet. In the Change event for said Combobox,
the code takes the text property that has been selected, and then changes a
pivot table page field to what was selected from the Combobox.

The code changes the pivot table okay, but when I click away from the
Combobox, the text in the Combobox reverts back to the previous selection.
Bizarrely, if I then click on the Combobox, it goes back to the selection I
just chose.

Even more bizarrely, this seems to happen randomly. Sometimes it behaves as
it should and then a few moments later it will start doing the above again.

Any ideas anyone.

Ta.

Neil

Is the combobox linked to a cell. If so, perhaps unlinking it will help.

You may also have other events that are being triggered that cause the
problem.

--
Regards,
Tom Ogilvy

"Neily" wrote in message
...
Right, this is doin' ma box in and wondered if anyone may have come across
this before and have a solution.

I have a Combobox on a worksheet. In the Change event for said Combobox,
the code takes the text property that has been selected, and then changes
a
pivot table page field to what was selected from the Combobox.

The code changes the pivot table okay, but when I click away from the
Combobox, the text in the Combobox reverts back to the previous selection.
Bizarrely, if I then click on the Combobox, it goes back to the selection
I
just chose.

Even more bizarrely, this seems to happen randomly. Sometimes it behaves
as
it should and then a few moments later it will start doing the above
again.

Any ideas anyone.

Ta.

Neil