Hi -

Is it possible to add a macro to a toggle button to change the
formatting of a group of cells? Currently, depending on whether the
toggle button is clicked, the cell will show a dollar value or a
percentage and I want the formatting to change from Accounting to
Percentage to reflect the data.

Example -
- When the button is not clicked, the value of cell A1 is 100 and
should be formatted $100.

- When the button is clicked, the value of cell A1 is .30 and should
be formatted 30%.

Any help would be greatly appreciated. Thanks.

Stephen