Prev: Hold a cell range for an "average formula"
Next: I can't input anything I type on Excel. What can I do? Nothing p.
From: DisMusBeDaPlaz on 28 May 2010 16:53
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

From: Normek on 30 May 2010 19:41
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
>
> .
>
 | 
Pages: 1
Prev: Hold a cell range for an "average formula"
Next: I can't input anything I type on Excel. What can I do? Nothing p.