RE: URGENT- Form design and field tab-order problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

From I can see you cannot accomplish what you want in the manner you are
doing it. One way to accomplish the tabbing from field to field is by
creating an Excel User Form, but this would require you to get into the
Visual Basic Editor (Alt-F11). Then you would select Insert from the menu
bar and then UserForm. This would then display the Toolbox and you would
place your controls on the form. Then in the properties box to the left
there is a TabIndex property for each control you could set. You would have
to create a macro button in the spread*** with a macro assigned to it that
launches the form. The only problem with this method (and it is significant
in your case) is that there is no other way to print the form other than a
print screen and copy to Word. The only other thing you can do is to create
a form in Word. The Word forum should be able to help you with this.

John


"Foxcole" wrote:

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 work*** 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 work*** 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.)

.

Quantcast