Help with a VBA Code (Dropdown list)

Hello Alpha,

First off all thank you for replying to this thread. I tried the code you gave. I am still not able to delete a value from the list and add new one without deleting the whole list.

N.B: i removed the code i have and put yours.