Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms, fields and tab order
My customer sent me some Excel sheets that I'm meant to convert into forms.
These are simple forms to facilitate user input (for service technicians to fill in checklists and create service estimates to be signed by customers) and will not be tied to any databases. I'm having trouble figuring out how to do this. I'd want checkboxes and radio buttons for the checklist items, and a textbox for the typed information. Simple enough, right? But, it isn't. The Control toolbar does have all the field types I need and it's easy to create the fields on the Excel sheet... but I cannot see how to set a tab order for them. So I next looked at just using the Excel cells instead of form fields, because I found a macro that creates a tab order... but we really do need the checkboxes and radio buttons, so this wouldn't work. I've spent hours trying to weed through information in Google searches and tutorials and Help files and discussion groups, but I cannot find this bit of information. All I can find are instructions on creating an Excel form tied to a database or how to create dialog forms. We also need to try to use as little VBA as possible, because the form owners won't be able to support it if anything changes or if problems arise. These forms need to be as up-front WYSIWYG as possible, just fill, print, sign and date. Could someone point me in the right direction? Is it possible to do this simply? Have I just been looking in all the wrong places for the right information? Also, just to note, we are not considering PDF forms; they need to be in Excel. The Adobe Reader EULA limits each PDF form to 500 uses (not 500 per user---500 total) before it's necessary to invest in Adobe's very expensive server-based forms software. We have too many users for PDF forms to be practical. (Adobe does not monitor form uses or number of distributions; it's an honor system. But regardless of what others are doing or how undetectable our usage might be, I cannot consciously put our company in an indefensible position.) Cheers! -- FoxCole "Drawing on my fine command of the English language, I said nothing." Robert Benchley (about his response to someone who said at a dinner party, "Say something funny, Mr. Benchley.") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the order of fields in a query | Excel Discussion (Misc queries) | |||
Excel 2003: Forms Fields | Excel Discussion (Misc queries) | |||
Need to automatically number order forms in excel upon opening? | Excel Discussion (Misc queries) | |||
Put form fields in Word forms into an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Excel Forms - text fields decompressing font automatically | Excel Discussion (Misc queries) |