If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yes - No Interactive Text Box
Working in Excel, I am looking for help using interactive fill-in check
boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not where you enter a question. Then that question can be answered by clicking in a "Yes", or "No" box. Then a "check mark" appears if their is not one, or, disappears if their is a "check mark" already present. Or, in the case of multiple responses as noted below. With the use of a conditional fill-in like box, you can enter a check-mark. [ ] Yes (or) [ ] No The boxes indicated are shaded in the top left and you can click to add or remove a check mark. Other condition where you can add multiple conditional fill-ins doing the same thing with multiple areas (i.e. Property, Location, Size, West, East, etc.) Thank you for your help in the urgent matter. DisMusBeDaPlaz |
#2
|
|||
|
|||
Yes - No Interactive Text Box
Hi DisMusBeDaPlaz,
You need to work with Excel Forms using VBA rather than on a spreadsheet. This is an easy task for one familiar with this part of Excel. An excellent tutorial can be found at : http://www.functionx.com/vbaexcel/ Hope this helps, -- Normek "DisMusBeDaPlaz" wrote: Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not where you enter a question. Then that question can be answered by clicking in a "Yes", or "No" box. Then a "check mark" appears if their is not one, or, disappears if their is a "check mark" already present. Or, in the case of multiple responses as noted below. With the use of a conditional fill-in like box, you can enter a check-mark. [ ] Yes (or) [ ] No The boxes indicated are shaded in the top left and you can click to add or remove a check mark. Other condition where you can add multiple conditional fill-ins doing the same thing with multiple areas (i.e. Property, Location, Size, West, East, etc.) Thank you for your help in the urgent matter. DisMusBeDaPlaz . |
Thread Tools | |
Display Modes | |
|
|