LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default URGENT- Form design and field tab-order problems

I've tried asking this question in other forums but either got no
response, or the one responder I did have couldn't provide an answer.
Maybe I've been asking the question the wrong way. Let's try this:

A requester sent several Excel files that have been formatted to print
out as forms. These forms should be filled out electronically by
service technicians in the field, then printed and signed by
customers.

The reason the forms are in Excel is that all service techs already
have and use Excel.

The forms do not need to fill in any worksheet ranges or databases.
All they need to do is provide clickable checkboxes, radio buttons,
and fields for entering comments, customer information and dates.

The service tech needs to be able to tab from field to field. Not
every field will need to be filled out each time the form is used.

Problems:
Because the forms do not use worksheet ranges or database, I chose to
create fields from the Control toolbox.

But I don't know how to set a tab order for these fields. I also don't
know what other types of actions are usually coded for the types of
fields I need, let alone where to find code I can use.

I imagine I should set a background shade when a textbox or checkbox
field is in focus, but how?
What considerations do checkboxes require?
How are radio buttons handled?
How can I control where the focus goes next when the user hits Tab?

I've spent almost two weeks trying to research this online. Microsoft
help pages are severely lacking in this level of detail. It took three
or four days just to discover that the Control toolbox creates ActiveX
controls.

Learning that finally enabled me to understand that I need to use VBA
to work with these fields---so I tried to sit down with the VBA help
files and start learning how to code them, but I just don't have time
to sift through it all.

Please help, if you can!! I'm desperate -- this project is several
days overdue now, and I have to get it done so I can move on. (It has
not helped at all that the Microsoft newsgroups have had connection
problems, "service temporarily unavailable", making my searches even
less fruitful and slower than they might have otherwise been.)
 
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
Active X Controls Tabbing from Form Field 2 Form Field Tfrup12 Excel Discussion (Misc queries) 0 February 19th 08 08:15 PM
Order form design Learner101b Excel Discussion (Misc queries) 3 December 18th 07 10:51 PM
how to design a form Allan Collings New Users to Excel 1 July 17th 06 12:47 PM
Design a form Cyrus New Users to Excel 2 May 9th 06 06:43 AM
design form? [email protected] New Users to Excel 5 January 31st 05 03:26 AM


All times are GMT +1. The time now is 05:22 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"