Microsoft Office Forums Automatic change content of a cell in table using dropdown list

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2019, 04:35 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default Automatic change content of a cell in table using dropdown list

Hello everyone,

I need some help in order to solve a problem related with MS Word VBA.

The problem is the following:



I have a car table that has 3 columns ("Model", "Year", "Price").
In each cell of the "Model" column I have a dropdown list. I want that: every time I change the car model in the dropdown list, it updates the price that is in the same row, although in the third column ("Price"). How do I do that?

I ask for help please, asap

Thanks in advance
Regards
Reply With Quote
  #2  
Old 10-14-2019, 05:22 AM
gmayor's Avatar
gmayor gmayor is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,000
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

How does the macro know what price to enter based on your dropdown list selection (and presumably the year)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 10-14-2019, 05:52 AM
gmaxey gmaxey is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Word MVP 2003-2009
 
Join Date: May 2010
Location: Marble, NC
Posts: 966
gmaxey will become famous soon enoughgmaxey will become famous soon enough
Default

Cross posted at: Automatic change content of a cell in table using dropdown list


You are wasting my time and Graham's when you do this.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #4  
Old 10-14-2019, 05:54 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default

Manually. I'll enter the values for each case in my macro.

For now I don't want to deal with year. I just want price for each model, so, after I change the model, then the price gets updated on that same table row.

For example, something like this:

.............

If ContentControl.Title = "CarsModelDropDown" Then
Select Case .Text
Case "Toyota Avensis"
myTable.Cell............. = "25000 usd"
Case "Nissan Skyline"
myTable.Cell............. = "65000 usd"

................

Can you help me?
If possible send me the word file (.docm) already working.
Please
Reply With Quote
  #5  
Old 10-14-2019, 05:57 AM
gmaxey gmaxey is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Word MVP 2003-2009
 
Join Date: May 2010
Location: Marble, NC
Posts: 966
gmaxey will become famous soon enoughgmaxey will become famous soon enough
Default

No. Because I already provided code that works in your cross post and you are now wasting our time.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #6  
Old 10-14-2019, 06:20 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default

Okay I understand, but I am newbie here in this forum.

Sorry for disturb you.

But, please send me the link (of related post) for the solution.

Thanks
Reply With Quote
  #7  
Old 10-14-2019, 06:45 AM
gmaxey gmaxey is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Word MVP 2003-2009
 
Join Date: May 2010
Location: Marble, NC
Posts: 966
gmaxey will become famous soon enoughgmaxey will become famous soon enough
Default

Jaimes,


Newbie or not, it doesn't take a rocket scientist to realize that if you post a question in two forums that two different people may be working at the same time to provide you a solution ergo one of them is wasting their time!

I posted a link to your cross post. You posted there, surely you can figure out how to go back and look.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #8  
Old 10-14-2019, 06:54 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default

I already used the model name as the list entry text, and the price as the list entry value.

But I am getting an error after put your code, as you can see here:


dropdown-problem1 — imgbb.com



vba-dropdown-error — imgbb.com

Please help me, coz I don't have skills in vba macro programming.

Sorry for the inconvenience
Reply With Quote
  #9  
Old 10-14-2019, 06:57 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default

Sorry, I don't even know the relation between the forums.
So I posted the question in many of them.
I apologize once again for the inconvenience.
Reply With Quote
  #10  
Old 10-14-2019, 07:12 AM
gmaxey gmaxey is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Word MVP 2003-2009
 
Join Date: May 2010
Location: Marble, NC
Posts: 966
gmaxey will become famous soon enoughgmaxey will become famous soon enough
Default

Oh more than two? Them you could be wasting "many" peoples time. Why don't you go back and let everyone know!!
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #11  
Old 10-17-2019, 05:33 AM
jaimes7 jaimes7 is offline Automatic change content of a cell in table using dropdown list Windows 10 Automatic change content of a cell in table using dropdown list Office 2016
Novice
Automatic change content of a cell in table using dropdown list
 
Join Date: Oct 2019
Posts: 6
jaimes7 is on a distinguished road
Default

I already solved the problem removing the vertically merged cells from the table

Okay sorry man..
For the next time I will comply with this.


Thank you
Regards
Reply With Quote
Reply

Tags
dropdown list, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic change content of a cell in table using dropdown list Auto populate a text field based on Content Control Dropdown List matthias92701 Word VBA 2 05-02-2019 03:54 PM
Content Control DropDown List gabster Word VBA 4 04-30-2019 09:53 PM
Dropdown list from a value of another cell in dynamic worksheet Javir Excel 5 06-07-2018 02:52 AM
Automatic change content of a cell in table using dropdown list How do I add selection of multi line content control list to specific table cell Dudlee Word VBA 1 09-20-2016 04:58 PM
Change cell color everytime a value is selected in dropdown list angelica_gloria Excel 4 01-27-2012 06:47 PM


All times are GMT -7. The time now is 11:24 AM.


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