tick box with formula

  • Thread starter Excel_Can_drive_me_Nuts
  • Start date
E

Excel_Can_drive_me_Nuts

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?
 
T

T. Valko

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"
 
Top