Hi,
I created a drop box that has 4 possible responses. Each response has a weight on it. I would like to create a function/macro/code to update the table cell with that weighted value.

For example:



Select color (blue =1, red =2, yellow =3) - Users selects red - Output = 2
Select Town (Boston=1, New York=2, LA = 3) - Users selects LA - Output = 3
etc... -----------------
Final Score = 5


Thanks

What kind of dropbox? Userform? ActiveX? Formfield? Content Control?
Where does the output go?

Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

"I created a drop box that has 4 possible responses."

blue, red, yellow, Boston, New York, LA

This is six.

Are you possibly talking about TWO different dropdowns. In which case, you need to answer macropod's question...where does the output go.