1) when I make the selection, say country and click on button 1, I will be seeing the required chart and when I click on button 2, the selection gets cleared off and when I click back on button 1 again, the selection made previously will be selected and this is how I need. But I am not able to make multiple selection for a single field i.e. when I select two or more countries, the concept above is not working. When I move from button 2 to button 1, everything gets cleared off.
2) Is it possible to select the not selected country when moving from button1 to button2. for ex,when a user selects two countries say CN and US when in button 1 and then the user clicks on button 2, the countries other than CN and US should be automatically selected.
I am using version 8.2 and so Set analysis won't help in my case. Any suggestions please.
The statement "ActiveDocument.Fields("Country").Selectexcluded" does exactly what you're looking for. Just remove the lines in the macro that clears the selections and it should work.
