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 an important practical feature to make your spreadsheets more usable, enable faster more consistent input and robust.   Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice.  For example if I …

Dependent Dropdown using INDEX Read More »

Tagged with: ,