Setting what #'s can be typed into a text form field

[Reliable1]

I am putting together an evaluation form in which each category can be scored
from 1-5. I would like to set it so that only 1,2,3,4 or 5 can be typed into
that field. Is this possible? How?

Any help is appreciated.

 

[Graham Mayor]

Use a dropdown form field with only those numbers available.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Reliable1]

if a dropped down is used can the number be typed in or do you have to use
your mouse?

 

[Jay Freedman]

The dropdown field can be used entirely with the keyboard, but it isn't
quite obvious how to do that. When the cursor is moved to the dropdown
field, you have to press Alt+down arrow to open the list. Then you can type
the desired number to select it, and tab out of the field.

There is a reminder there, if you know what it means: The arrow button next
to the field has an underline below the arrow, and just like the underlined
letter in a menu item, it means that you hold the Alt key while pressing the
"shortcut", in this case the down arrow key.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Reliable1]

Last question. Can columns with several dropdowns be added/totaled if so how?
Thank you for your assitance.

 

[fumei via OfficeKB.com]

Yes. Are you asking about dropdowns in a column in a Word table? I am
assuming this is the case.

You could have a text formfield with an OnEntry macro that when you Tab into
it, would get all the values of the dropdowns, total them, and write that
value.

There are other possibilities.

Last question. Can columns with several dropdowns be added/totaled if so how?
Thank you for your assitance.

The dropdown field can be used entirely with the keyboard, but it isn't
quite obvious how to do that. When the cursor is moved to the dropdown

[quoted text clipped - 24 lines]

 

[Reliable1]

Where would i get this Onentry mscro that will perform this function. Never
done this. Help is greatly appreciated.

Yes. Are you asking about dropdowns in a column in a Word table? I am
assuming this is the case.

You could have a text formfield with an OnEntry macro that when you Tab into
it, would get all the values of the dropdowns, total them, and write that
value.

There are other possibilities.

Last question. Can columns with several dropdowns be added/totaled if so how?
Thank you for your assitance.

The dropdown field can be used entirely with the keyboard, but it isn't
quite obvious how to do that. When the cursor is moved to the dropdown

[quoted text clipped - 24 lines]

Any help is appreciated.

 

[Graham Mayor]

Each dropdown field will have a bookmark name, by default Dropdown1,
Dropdown2 etc. Check the calculate on exit checkbox property of the last
field to contribute to the calculation, and where you want the total use a
formula field eg
{ ={ Dropdown1 } + { Dropdown2 } }
note all field bracket pairs are inserted with CTRL+F9.

You could do much the same by macro to enter the calculation in another form
field eg to put the same dropdown form field results into a form field
"Text1"

Run

Sub CalcDD()
Dim oFld As FormFields
Dim x As Long
Dim y As Long
Set oFld = ActiveDocument.FormFields
x = oFld("Dropdown1").Result
y = oFld("Dropdown2").Result
oFld("Text1").Result = x + y
End Sub

on exit from Dropdown2
Frankly using formula fields is far simpler for such a task.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Where would i get this Onentry mscro that will perform this function.
Never done this. Help is greatly appreciated.

Yes. Are you asking about dropdowns in a column in a Word table? I
am assuming this is the case.

You could have a text formfield with an OnEntry macro that when you
Tab into it, would get all the values of the dropdowns, total them,
and write that value.

There are other possibilities.

Last question. Can columns with several dropdowns be added/totaled
if so how? Thank you for your assitance.

The dropdown field can be used entirely with the keyboard, but it
isn't quite obvious how to do that. When the cursor is moved to
the dropdown
[quoted text clipped - 24 lines]

Any help is appreciated.