Hello everyone, very new to VBA (new= just started learning this week) and have an immediate need for a solution, so apologies if I am asking something obvious before scouring the forum/internet for a specific answer. This should be simple enough
My scenario:
I have a dropdown menu/data validation on one cell (we'll call "Items") and another cell called "Enter Item Manually." One of the options in the "Items" dropdown is "Blank." When "Blank" is selected, I want the "Enter Item Manually" cell to behave like an empty cell, one where a user could enter whatever value they would like to. When anything else besides "Blank" is selected from the dropdown, I want the "Enter Item Manually" cell to say "Item Selected Above" and be non-editable, or "locked" as I called it in the title of this thread.
Currently, I'm using this simple VBA (written on the sheet object) to keep the "Enter Item Manually" cell clear when there is a Worksheet Change event:
Though this more or less does what I need, I want what I've described above to happen. Plus, worksheet change events are new to me, and I've caused problems/infinite loops when tweaking this little bit of code. I assume there is a better alternative. Any thoughts?
Bookmarks