Just link your checkbox to the cell it floats over, then run your macro based
on whether that cell is true or false.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


" wrote:

I have the following information:
Column A Column B Column C
Revenue 1000.0 1200.0 1300.0
Expense $500.00 $300.00 $200.00
Margin $500.00 $900.00 $1,100.00

I am adding a check box in the bottom of each column and I need to
created a macro that when I check the box (true) it will copy and
paste as a value the data above the check box.
thanks for your help.

Pantera