Cell value only from combobox selection

[ipbr21054]

Morning,
Not sure if this is possible but i would like to ask.

Sheet1 cell P7
I would like the value to only be able to enter this cell from my combobox1 in N7
I do not want it possible to allow the use to type a value into this cell.

Example
Say you select from the combobo1 the selection called UK
Then the value 99 is put into cell P7
This is correct.

However if you manually type 46 into cell P7 then the combobox will still show UK which is incorrect and the two references do not tie up.

 

[NoSparks]

Lock the cell and protect the sheet.
From the event you use to write to P7
unprotect sheet, write to the cell, reprotect sheet.