Use Combobox List Instead Of Data Validation Dropdown List

[alansidman]

Here is a link to a Debra Dalgleish tutorial on using a combo box instead of DV. Good luck with your project.
I have also change your combo box in the attached to an Active X linked to the appropriate cells as Debra explained.

Alan

Combo Box Drop Down for Excel Worksheet « Contextures Blog