Prevent deleting value in drop down list

[Randy26]

Hi everyone,

I have a cell with data validation allowing for 5 possible choices.
I am trying to find out if it is possible (once a value has been selected and without using the sheet's events) to prevent the user from selecting the cell and typing Delete which empties the cell?

Thanks

Randy

 

[James006]

Hi,

You should clarify your objective ...

With your description ... it is not possible without using VBA ...

By the way, would you like to allow the user to change his mind ...

 

[Randy26]

Hi,

You should clarify your objective ...

With your description ... it is not possible without using VBA ...

By the way, would you like to allow the user to change his mind ...

Hi James

Yes, the user should be able to change his mind and select the first possible value, then the fifth, then the fourth etc. as many times he wants. But once he selected something, I'd like to prevent him from deleting the content of the cell.

So you say there's no way to achieve this without VBA code?

 

[James006]

Hi,

Without VBA ... no...

Since you want to lock the cell after its final modification ...

By the way ... you will need the User to indicate he is done with all his potential modifications ...