Using activex combobox to insert value in a data validation cell

Greetings everyone!

I have a problem that i hope somone can help me with. I have a worksheet that has a data validation cell and i want to be able to use an activex combobox to insert data into. I can get the link to work sucessfully, but i am having problems with the formulas responding the way i need them to. i have attached an example worksheet detailing the issue. Any help would be most appreciated. If i am going about this problem the wrong way or if there is a better way, please let me know. Thanks in advance!

See attached worksheet: