Extract the value of check box's which are clicked..

[itsmesunilb]

Hi,
I was trying to automate my report whereby I am using Checkboxes. I have inserted 4 checkbox's which read as Bill, AP1, RTF, NEW

I linked the checkbox to cells which read as True whichever I click. Now, I want to extract the checkbox text which are clicked.
Suppose I click on Bill and AP1, then I want to extract the text of these checkbox in empty cells.
How can I achieve this...
thanks

[rodrignj]

I am not very clear on your objectives here but, taking your issue at face value: if you're checkbox is already providing a true/false in a designated cell when it is clicked you could use =if([checkbox true/false]=true,"Bill",""). You're not "extracting" the value of the checkbox, just understanding that, that is the value to which that cell is referring.