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