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

In design mode, right-click your checkbox and select Properties. You should
have an option for 'LinkedCell'. Set the cell that you would like the
checkbox linked to.

HTH,
Paul

--

wrote in message
...
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