|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to update a table cell with a value based on a drop down box entry
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
"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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop-down Populated with text entry | ReviTULize | Word VBA | 14 | 02-21-2013 07:06 PM |
Update Word table based on another table input | mpdsal | Word VBA | 10 | 10-29-2012 07:40 AM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Hide Rows and Update Chart based on cell value | ubns | Excel Programming | 5 | 05-07-2012 05:44 AM |
Sequentail Number Each Row Based On Another Column Entry | KramerJ | Excel | 3 | 05-07-2009 11:35 PM |