Form Fields

K

kdc.cap

In WORD, from the Forms toolbar, it is possible to create shaded form fields for information, then Lock the document so that users tab from field to field providing the requested information. Is such a feature available in Excel?
 
D

Dave Peterson

You can colorize cells (format|cells|pattern).

and you can lock the cells that shouldn't be tabbed to and unlock the cells that
should.
(Format|cells|protection tab)

Then when you protected the sheet, the user will be able to tab to the unlocked
cells.
(Tools|Protection|protect sheet)
 
H

hnyb1

Yes, but can you program the cells to lose their shading when the user has
filled in the cell?
 
D

Dave Peterson

Maybe format|conditional formatting.

with a formula like:
=LEN(A1)<>0

and font colors and patterns turned off.
 
M

mcaalcorn

Ok people yall are not giving this person the specific answers to her question.
I have created a wonderful form which uses the tab feature and the mouse to
click on the drop down boxes, and the mouse to click the check boxes.

You have to turn on the forms feature by clicking view/toolbars and then
clicking forms. This will bring up the form toolbar.

The secret to using tab and having your form remain its professional
intergrety is to use the chart box for your place holders. You have a
feature on the drawing toolbar which allows you to select No Border.

When you create your chart using this feature the borders will be pale
colored, and will not print.

You have to make boxes for the data entry spots which will have to be
formated Tools, Table propertys, cell, is exactly .2 or .3 depending on the
size of your font. This makes the person who happens to hit enter not be
able to "change the spacing".

Ok, the highlighed portion which no one told you will be there if you click
on the AB located on the Forms tool bar. If you data should only be a
certain amount of spaces you will click the AB, then right click and change
the number from unlimited to the exact number of spaces requried for the data.

Such as the date feature does not properly work the way I want it to to I
create my cells using a box for the month, click AB, then right click and
limit to 2 letters, I insert a box for the / and then another AB for the
date limited to 2 letters, another box for / and then i input 06.

You must protect the doucment to have it function as a form, so click tools,
protection, and trust me in the beginning stages of creating forms, use a
single letter or number for your password, however if you know how to give
yourself full priviledges and take them away from everyone else that might
have access to your forms in progress folder you can simply click the lock
icon (it looks like a lock) and once you enter the password one time you
simply keep clicking the lock icon.


If any of you care to email at [email protected] I will send you a copy of
one of my form so you will see exactly what I am talking about and can get
ideas for your forms (that is if you like my ideas)
 
Top