![]() |
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 |
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 . |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com