input box to change formula in calculated field

[mumsys]

Hi,
I have a problem.
I was thinking about my macro, and i need it to go like this:

User puts a value o percentage loss that he would like to define and then macro change this value in the calcualted field.
i dont really know how to write it down. i have something like this so far.
I would like to look like this:

User puts a value that of index that he wants (10% makes 0.9/1/1.1, 20% makes 0.8/1/1.2 in the following formula) and macro change the formula in the calculated field.

Please Login or Register  to view this content.

Now i get wrong numbers of argument or invalid property assignment :/

[mumsys]

Please Login or Register  to view this content.

This kinda works, but i can't apply it to every pivot table in every worksheet in my file :/

[mumsys]

Bump, is there any idea?

[mumsys]

http://www.ozgrid.com/forum/showthre...922#post678922

Another post on ozgrid