I did everything as you described in video...make a table...give it name range...validat...and when I put in a new item I get error...value entered not valid...user has restricted values that can be entered...what am I doing wrong...thank you
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation
0
Discussion
You can't add a new item to a validated cell. The addition must be made to the list in the named range. There is a way to allow unlisted entries in the validated cell but that won't add the item to the list for future use and, in many cases, allowing unlisted items to be entered defeats the purpose of having validation in the first place.
Variatus (rep: 4889) Feb 19, '20 at 8:44 pm
Upload a sample file and it will be easier to point out the error, it's something with validation on the cell with the drop down or maybe you mean where you have the list stored? If you don't want to upload a sample file, just remove all data validation form the worksheet and start fresh and it should work.
don (rep: 1989) Feb 20, '20 at 2:55 pm
Ok I see what I was doing wrong...My list of items are on a differant page...so I did everything on my List page and when I went to my page with the Valadation, I was trying to put in new items there instead of on the table list on my list page...I got it...thanks for the help and patients...
Ojiisanusa Feb 20, '20 at 3:35 pm