tick box with formula
 

I am designing a sales pipeline which is easier and faster to complete. I am
utilising checkbox controls and this is working ok. My question is: Am I able
to have the contents of a cell copied into another cell on a new sheet
(within the same workbook) when a tick box is activated?

tick box with formula
 

If you have the checkbox linked to a cell you can do something like this:

When the checkbox is checked the linked cell will evaluate to either TRUE
(checked) or FALSE (not checked)

Linked cell is Sheet1 A1

=IF(Sheet1!A1,Sheet1!B1,"")

Biff

"Excel_Can_drive_me_Nuts"
wrote in message
...
I am designing a sales pipeline which is easier and faster to complete. I
am
utilising checkbox controls and this is working ok. My question is: Am I
able
to have the contents of a cell copied into another cell on a new sheet
(within the same workbook) when a tick box is activated?