#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
No. Because I already provided code that works in your cross post and you are now wasting our time.
|
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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. |
#10
|
|||
|
|||
Oh more than two? Them you could be wasting "many" peoples time. Why don't you go back and let everyone know!!
|
#11
|
|||
|
|||
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 |
Tags |
dropdown list, table |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |