I have a list of names in a Sheet Column A.
A
---
Robby
Harry
Nick
In any cell when I enter a name and click on other cell. If the entered name not present in the list then the focus shouldn't move to other cell. I shouldn't be able to select other cell or move the cursor.The cursor should only be focused to the entered cell. Cursor should be locked until I won't enter name given in list. Once I enter name in given list I should be able to move cursor to other cell.
So how can I lock the cursor to specific cell and focus to only that specific cell using VBA code in Excel.