Forum Discussion
Connect cells to dropdown menu
Hello.
I'm trying to connect certain cells to a dropdown menu and I still want to be able to write in the cells that's connected to the drop down. In other words, I want to be able to change value ...
Are you saying that you want to be able to type a value into a validation drop down list that doesn't exist in that list? And you want that value to then be added to the original drop down list?
You can easily change settings to allow any value to be typed into the list, but adding it to the original list requires VBA.
You can easily change settings to allow any value to be typed into the list, but adding it to the original list requires VBA.