How to Automatically Add to a Data Validation List? I know how to create a validation list and also allow user do manual entry in the cell by turning off the "Stop" error message. But how can I allow user to add new entries when they type in the drop down list while the record is not exist in my original validation list? How to make below codes work? Thanks
Please Login or Register to view this content.
Bookmarks