Tag: Data Validation dropdowns

Posted on by JohnHackwood Posted in Macros, VBA

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown …

Autocomplete Workaround for Validation Dropdowns Read More »

Tagged with: , , , , ,

Posted on by JohnHackwood Posted in Data Validation

Data Validation Dependent Dropdowns are important practical feature to make your spreadsheets more usable and robust.   Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice.  For example if I have a data set with say …

Dependent Dropdown using INDEX Read More »

Tagged with: ,