Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2013, 02:03 PM
mkasem mkasem is offline Trying to update a table cell with a value based on a drop down box entry Windows 7 32bit Trying to update a table cell with a value based on a drop down box entry Office 2010 32bit
Novice
Trying to update a table cell with a value based on a drop down box entry
 
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 Trying to update a table cell with a value based on a drop down box entry Windows 7 32bit Trying to update a table cell with a value based on a drop down box entry Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-29-2013, 08:36 PM
fumei fumei is offline Trying to update a table cell with a value based on a drop down box entry Windows 7 64bit Trying to update a table cell with a value based on a drop down box entry 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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to update a table cell with a value based on a drop down box entry Drop-down Populated with text entry ReviTULize Word VBA 14 02-21-2013 07:06 PM
Trying to update a table cell with a value based on a drop down box entry 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
Trying to update a table cell with a value based on a drop down box entry Hide Rows and Update Chart based on cell value ubns Excel Programming 5 05-07-2012 05:44 AM
Trying to update a table cell with a value based on a drop down box entry Sequentail Number Each Row Based On Another Column Entry KramerJ Excel 3 05-07-2009 11:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft