View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Normek Normek is offline
external usenet poster
 
Posts: 42
Default 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

.