Martin Liss has been gratious in working with me through a very complex Macro. He has advanced this to the next stage.
Here is what I need.
There are two separate Macros.
One macro "watches" to see if a row is selected by a doubleclick that results in a check mark. If it is selected, then the math is to take the cell in the % / $ Table and apply the $ value to the bottom cell at the base of the Table.
The second Macro simply, at the push of the Button (blue), converts all the table values from % to $ and back again with another push of the button.
Currently, the selection process in column A results in not converting the % to $ (and vice versa) in the table; nor does it update the Sum at the bottom.