Automatic change content of a cell in table using dropdown list

[jaimes7]

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

 

[SkipVought]

Hi,

Where is the table that associates the Model with the Price?

Actually, I'd assume that BOTH Model AND Year would be needed to locate Price.

This would be easy in Excel!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[macropod]

Cross-posted at:

https://www.office-forums.com/threa...-a-cell-in-table-using-dropdown-list.2350685/

Please read Tek-Tip's policy on Cross-Posting:

http://www.tek-tips.com/market.cfm

Also cross-posted at:

https://www.excelforum.com/word-pro...t-of-a-cell-in-table-using-dropdown-list.html

Cheers
Paul Edstein
[MS MVP - Word]

 

[jaimes7]

I understand that I have posted in several forums the same question.
Honestly, I don't see any problem with that. I don't even know the relationship between the forums. And what's the matter with that?
I just want you to help me solve my problem, please.
If I posted in various forums is because I have some urgency.

 

[DjangMan]

OP - You've been asked a question about your data here that you haven't answered but you've taken the time to copy/paste your reason for crossposting in all three places. With regards to crossposting - it's just the rules at the various forums.

 

[SkipVought]

Where is the table, as I asked 2 dats ago?

You need data to accomplish what you ask.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Andrzejek]

Maybe it is a case of: "I have a car table on the back of the napkin that has 3 columns ("Model", "Year", "Price"). "


---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

Well, the OP stated "some urgency."

It seems that the operative word in this phrase is "some" rather than "urgency."

In some quarters we might say "time is of the essence!"

The OP must mean,

"Time is of SOME essence!"



Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[macropod]

I understand that I have posted in several forums the same question.
Honestly, I don't see any problem with that. I don't even know the relationship between the forums. And what's the matter with that?
I just want you to help me solve my problem, please.
If I posted in various forums is because I have some urgency.

Kindly read the forum rules. If you can't be bothered complying, don't expect any help...

Cheers
Paul Edstein
[MS MVP - Word]

 

[mintjulep]

Urgency ends when (homework) deadlines pass.

 

[jaimes7]

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

Thanks

 

[SkipVought]

Your reply implies that you have received a solution.

For the benefit of all our members, please share your solution, as is customary here at Tek Tips.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein