Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcaalcorn
 
Posts: n/a
Default 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)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create drop down form fields in Excel? Micki Excel Discussion (Misc queries) 4 January 3rd 08 03:41 PM
How many fields can you have in an EXCEL form? Is there a limit? Graciemygirl Excel Discussion (Misc queries) 3 February 8th 06 03:50 AM
can we link fields from a form in word document to excel Sunil Excel Discussion (Misc queries) 0 February 6th 06 09:26 PM
Create fields in a form with a fixed length sgeels Excel Discussion (Misc queries) 1 November 12th 05 05:11 AM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"