VBA pop-up message box for each selection of a drop-down list

[Gtasios4]

Dear All,

In the below excel table-tool I want to create pop-up messages for each selection of the drop-down list (B2) as well as to change the message box when the user alters his selection.

I don't know maybe if it finds in cell B2 the value Audi then pop up the message etc..

Is it possible also the message box to have content with bullets, such as the below? Regarding the response buttons instead of vbYesNo could they be replaced with Continue & Cancel Button?

• CO2 emissions (WLTP)
• Combined fuel consumption (WLTP)
• Acceleration 0 - 100 km/h
• Maximum speed

Brand List

Citroen

Audi

VW

Any help would be much appreciated!