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 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

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

Excel VBA IF THEN Statement (and a useful tip)

Excel VBA IF THEN Statement is one of the most useful statements in VBA. In this tutorial, you'll quickly learn how to work with the IF, THEN, ELSE, ELSEIF as well as the AND statements. This way you can write Excel macros that are

Excel VBA FIND Function

Excel VBA FIND Function (& how to handle if value NOT found) Doing a CTRL + F on Excel to find a partial or exact match in the cell values, formulas or comments gives you a result almost instantly. In fact, it

VBA Copy Paste

Excel VBA Copy & Paste in Excel VBA (copy, pastespecial, resize & offset) This tutorial shows you how you can copy and paste with VBA. We use the copy method as well as the pastespecial method. The copy method in VBA, copies

VBA Writing To Ranges

Excel VBA Referring to Ranges & Writing to Cells in Excel VBA (Range, Cells, Offset, Names) It's important to be aware of the different ways you can write to Excel cells with VBA. The macro recorder has its own preference when writing

VBA Object Properties & Methods

Excel VBA tutorial for beginners: Object Properties & Methods Understanding Objects, Properties and Methods in VBA is really important if you'd like to write your own Excel VBA code from scratch or update the VBA code you find on forums. This Excel

Excel VBA to Copy Data from one Sheet to Another

Can the Macro Recorder dynamically find the end of a range? This is where relative and absolute macro recording come into play. Each one has their advantages and disadvantages. In this tutorial I show you how you can use the macro recorder to copy

The Visual Basic Editor (VBE)

Excel VBA tutorial for beginners: The Visual Basic Editor (VBE) This tutorial is your introduction to Excel's Visual Basic Editor (VBE). This is the place macros from the macro recorder are recorded as well as the place you'll be writing any VBA