[Kathleen]

Sorry, I'm a bit confusing at times. In setting up a form, one area has drop
down boxes...there are 17 individual lines that need to be summed at the end
of the form. Its for a performance appraisal. I thought using the drop
down box would keep users from entering anything but the items offered but
now can't get the word form to total the points. The options given in the
drop down box are 1, 5, 3, n/a.

Is there a way to limit what numbes the user enters to 1, 5, 3 or n/a? If
drop down boxes are the best option, is there a way to sum the data chosen
from the 17 drop down boxes?

"alborg" wrote:

Hi Kathleen:

What do you mean that you couldn't get the dropdown to not work? When the
UserForm pops up, simply use the initialize routine to set it up. Do
something like this:

With ComboBox1
.AddItem "D.D.S."
.AddItem "D.O."
.AddItem "M.D."
.AddItem "R.N."
End With

You can also use checkboxes, and assign the result to a variable.

Al


"Kathleen" wrote:

Is there a way to allow the form user to enter in only certain options? For
example, a choice of 1, 2 or 3? And then have those choices added together
for a total figure? I've been trying to get the drop down box option to work
but so far no luck. Maybe its because one of the choices is n/a?