IF Function Question

  • Thread starter Thread starter nwhusker
  • Start date Start date
N

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to clear checkboxes 5
check and uncheck macro 5
Check Boxes 1
IF checkbox is checked/unchecked, Cell.value = yes/no 3
Add a checkbox to a spreadsheet 2
Can I update a date formula only if checkbox changes? 1
Macro to clear checkboxes and protected cells 2
Change a cells value with a function 4

Back
Top