Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
How many fields can you have in an EXCEL form? Is there a limit? | Excel Discussion (Misc queries) | |||
can we link fields from a form in word document to excel | Excel Discussion (Misc queries) | |||
Create fields in a form with a fixed length | Excel Discussion (Misc queries) | |||
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? | Excel Worksheet Functions |