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