vba code

[prashanthdivya]

Hi

Can any one help me with a VBA Code which would ask me to select a value between N or S. If I select "N" then the pivot field items "Guj","Del","Mum" should get selected.
If i select "S" then the pivot field items "Bng","Kar","KER" and "TIR" should get selected.

Thanks

 

[Jerry Sullivan]

Hi again prashanthdivya,

You can use the InputBox Function to request the response from the user.
(See Excel VBA help for syntax).

Depending on the user's response, you can filter a specified PT field to show items the items in your specfied list using the Filter_PivotField function code shown in this thread (post #8)
http://www.mrexcel.com/forum/showthread.php?t=589795

This should get you started in the right direction. If you get stuck,
just post the code that you are trying and explain what isn't working.

 

[prashanthdivya]

Hey Jerry,

Thanks for your response. I would give it a shot . Any help needed will get back to you