Yes - No Interactive Text Box

  • Thread starter Thread starter DisMusBeDaPlaz
  • Start date Start date
D

DisMusBeDaPlaz

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
 
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top