ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Yes - No Interactive Text Box (https://www.excelbanter.com/excel-worksheet-functions/264862-yes-no-interactive-text-box.html)

DisMusBeDaPlaz[_2_]

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


Normek

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