Hi,

I have created a list box with Multiselect option. The list box
contains the list of 12 months

All - To select all months
July
August
September
October
etc......


I have multiple pivots at the back end. The user has to select the
option (One or more months) on the main sheet. Based on his selection
for eg... July and August, the macro should trigger the change of that
field in the pivot tables.

I have six different pivot tables with different views. All of them
should be filtered to July and August. The user has the flexibility to
select any number of months or a single month.

Can some please advise how to write code for this.

Regards
Sandip.

On Aug 31, 3:33*pm, Sandip wrote:
Hi,

I have created a list box with Multiselect option. The list box
contains the list of 12 months

All - To select all months
July
August
September
October
etc......

I have multiple pivots at the back end. The user has to select the
option (One or more months) on the main sheet. Based on his selection
for eg... July and August, the macro should trigger the change of that
field in the pivot tables.

I have six different pivot tables with different views. All of them
should be filtered to July and August. The user has the flexibility to
select any number of months or a single month.

Can some please advise how to write code for this.

RegardsSandip.

Hi Apprecaite some one's help on this. I just would want to understand
how to write the code for this.

Regards
Sandip