Prevent manual input to cell but allow input from Listbox

[AdrianNeal]

Hi
i have sheet that allows the user to input data into a cell from selecting it from a Listbox on Userform. The values in the Listbox are from a named Range.
But the user can still manually write directly into the cell and can therefore input any value, even if its not in the named range, and I don’t want them to be able to do that.
is there a away ?

 

[offthelip]

You could use data validation on the cell using the same named range

 

[DanteAmor]

You must protect the sheet. Lock the cell.
Then in the code to pass the listbox data to the sheet, you must unprotect the sheet, put the data and re-protect the sheet.

eg.

    ActiveSheet.Unprotect
    Range("D10").Value = ListBox1.Value
    ActiveSheet.Protect

 

[AdrianNeal]

thanks guys,
came to a similar conclusion last night, But I decided to block the user from manual data entry with

ActiveSheet.Protect UserInterfaceOnly:=True

 

[DanteAmor]

You're welcome and thanks for the feedback.