| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Checkbox can be regconized in a formula and be executed
I would like to know how to put a check box in my XLS worksheet, then I can
write formula in an other cell B1 as "=IF (Checkbox(A1)=True, "OK, checked", "Not checked") ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Checkbox can be regconized in a formula and be executed
You can show the Forms toolbar and add a checkbox to the worksheet.
But rightclick on that checkbox and select Format control. Then use a cell link (adjacent to that checkbox??) And then you can test that link: =if(b3=true, "checked","not checked") Tr Huynh wrote: I would like to know how to put a check box in my XLS worksheet, then I can write formula in an other cell B1 as "=IF (Checkbox(A1)=True, "OK, checked", "Not checked") ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Hybrid Mode
