I'm looking for a simple macro that is driven by a change to a cell (see Sample; Cell E5). If the Condition is set to % then the input cell is represented as a % and the calculation is made as D5 * E5% and placed in F5. If the button is pressed and changed to $, then the value in cell E5 is changed to a $ value and F5 is recalculated as D5-E5$ and placed in F5.
It needs to be separated into 2 subroutines; one for % and one for $ change so they can actually be called from other macros to impact the same cells. Big cudos for actually making the button change from $ to % when clicked and selecting the right macro.