Excel VBA GetOpenFileName to Browse and Select File

Dynamic User File Selection Using Excel VBA GetOpenFilename Method This post will demonstrate how we can allow a user to select a file using a traditional “open file”-type dialog box. This has tremendous advantages over hard-coded solutions where the filename and its

Sum Cells by Color

Sum Cells by Color In this VBA tutorial we will look at a way to sum cells based on their background color. Unfortunately, Excel does not possess a function that will provide this functionality. So how will we get this to work?

How to use the Message Box in Excel VBA

How to use the Message Box in Excel VBA (syntax you'll need for MsgBox) In this tutorial you'll quickly learn the correct syntax to create a VBA message box (also referred to as a pop-up dialogue box) in Excel. I first show

Excel VBA Data types, DIM & SET (Learn to use them correctly)

Data Types, DIM & SET (Learn to use them correctly) “Data types for variables.  Why are they important?  Why do we need them?” These are very good questions. To be honest, you can write perfectly acceptable programs and procedures without using data

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