In my applicaiton there are 7 charts. On selecting some charts like(1,2,3,4) certain multi box should be visible. And when im selecting the other charts (5,6,7,) someother multi box should be visible , by hiding the previous multi box. vise verss...
How can i do it using macro..
Please provide a solution,