ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Form Fields (https://www.excelbanter.com/excel-discussion-misc-queries/75056-re-form-fields.html)

mcaalcorn

Form Fields
 
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 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)





All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com