Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-11-2013, 02:03 PM
mkasem mkasem is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jun 2013
Location: US
Posts: 1
mkasem is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-29-2013, 08:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,331
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-29-2013, 08:36 PM
fumei fumei is offline Windows 7 64bit Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

"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.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 04:36 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft