View Full Version : Solved: Control Toolbox Checkbox- If statement?

11-20-2006, 07:31 AM
I have a control toolbox checkbox placed on a worksheet when this toolbox is checked i'd like to perform the index operation on a table and output a value to a cell. How can i go about doing this?. Can i use an if statement in excel to output to the cell? example: If checkbox is selected perform the index operation else do not perform the function and outupt "NA" to the cell value.

11-20-2006, 08:26 AM
Hi pico,
might be easier using a checkbox from the forms toolbar. Take a look at the example....check out the linked cell by following directions in the textbox to see that the linked cell will have a true/false boolian response to clicking the checkbox. You can use formula's to act upon that response. Hope this helps.

11-20-2006, 08:53 AM
Once again Thanks Lucas....you are my saviour!. :rotlaugh:

11-20-2006, 08:57 AM
Glad I could help...be sure to mark your thread solved using thread tools at the top of the page. You can still post to this thread if you have more questions on it later.