I have this WS that Martin Liss has graciously helped me with and has done a great job in getting this to this level.
What I need is a correction to the Macro that does the following.
Current State: Currently you put in a % value in a % table (e.g. E8:G11, and defined as a RangeName). Then you put in a value in the Answer to a Question (in this case C12). You can then select (by double Clicking the A Column in the Black Boxes) a particular row of your choice to calculate a total value that is placed in E, F and G 12. When you change your choice in the check boxes (column A), the values in E, F and G12 should automatically adjust. When you fire the BUTTON macro button, all of the % values in the Table should change to Dollars. Presently they are dependent on the checked boxes. This should not be the case. The conversion of % to $ in the table is independent of the selection and summary.
Request: I need it so that when firing the BUTTON macro, all of the boxes change in the table from % to Dollar and back. HOWEVER, only the selected (checked) values are used to SUM the value at the bottom of each row in the table. This should happen WITH A MACRO THAT LOOKS AT COLUMN A AND UPDATES THE SUMS IF THE ROW IS SELECTED.
I hope that is clear. File attached for you to see.
Thank you in advance.