Reset Dependent Drop-down in Excel

Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value

Excel Dependent Combo Box Solves an Annoying Problem

This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) In this tutorial you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent

Excel VBA: Check If File or Folder Exists (DIR)

Excel VBA: Check If File or Folder Exists (DIR) Open File or Create Folder The DIR VBA function plays an important role if you need to refer to other files or folders in your macro.  DIR returns a string that represents a directory

3 Ways to Transpose Excel Data

3 Ways to Transpose Excel Data (Rotate data from Horizontal to Vertical or Vice Versa) Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows

Excel Dynamic Arrays – Excel will never be the same

Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything

Excel ActiveX Combo Box with VBA

How can you make navigation easier for your larger workbooks? You could create an ActiveX combo-box that automatically adds the sheet names to the drop-down. Once the user selects a sheet, they jump to the respective sheet. If the user deletes a sheet, renames