IF Function question

[nwhusker]

Hi,

I am using a worksheet with Checkboxes included. I need to create a
function that if the checkbox is checked, a value will show in another
cell. I can't figure out how to make the logical test relate to the
control/form checkbox. Is it possible to do this? Or do I need to
create a macro in VB to do this? Any ideas?

Thanks,
Carl

 

[Mangesh]

Right click on the control (checkbox in your case). Go to properties.
Linked Cell. Mention some cell say A1. This cell is now linked to your
control. You can then use this cell for your logical tests. You don't
need an macro.