Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBAâs catch-all error. Here are the 7 causes I see most often â with the exact fix for each.
Read article âCategory Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
VBA Plus / Macros Chapter â 1 (Swap Values – 1)
VBA Plus / Macros Chapter â 1 (Swap Values – 1)
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later.âŚ
Read article âBasics of VBA / Macros Chapter â 90 (Userform Part-11)
Basics of VBA / Macros Chapter â 90 (Userform Part-11)
Interactive Userform Below we will look at a program in Excel VBA that creates an interactive Userform. The Userform we are going to create looks as follows:âŚ
Read article âBasics of VBA / Macros Chapter â 89 (Userform Part-10)
Basics of VBA / Macros Chapter â 89 (Userform Part-10)
Userform with Multiple Pages Below we will look at a program in Excel VBA which creates a Userform that contains multiple pages. This userformâŚ
Read article âBasics of VBA / Macros Chapter â 88 (Userform Part-9)
Basics of VBA / Macros Chapter â 88 (Userform Part-9)
Controls Collection When creating Userforms in Excel VBA, you can use the Controls collection to easily loop through controls and set a property of each control toâŚ
Read article âBasics of VBA / Macros Chapter â 87 (Userform Part-8)
Basics of VBA / Macros Chapter â 87 (Userform Part-8)
Loop through Controls With just a few lines of code, we can easily loop through controls on an Excel VBA Userform. The Userform we are going toâŚ
Read article âBasics of VBA / Macros Chapter â 86 (Userform Part-7)
Basics of VBA / Macros Chapter â 86 (Userform Part-7)
Dependent Combo Boxes Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes. The Userform we are goingâŚ
Read article âBasics of VBA / Macros Chapter â 85 (Userform Part-6)
Basics of VBA / Macros Chapter â 85 (Userform Part-6)
Multicolumn Combo Box Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box. The Userform we areâŚ
Read article âBasics of VBA / Macros Chapter â 84 (Userform Part-5)
Basics of VBA / Macros Chapter â 84 (Userform Part-5)
Multiple List Box Selections The MultiSelect property in Excel VBA allows a user to select multiple items in a list box. The Userform we are going to createâŚ
Read article âBasics of VBA / Macros Chapter â 83 (Userform Part-4)
Basics of VBA / Macros Chapter â 83 (Userform Part-4)
Progress Indicator Below we will look at a program in Excel VBA that creates a progress indicator. We've kept the progress indicator as simple as possible, yetâŚ
Read article âBasics of VBA / Macros Chapter â 82 (Userform Part-3)
Basics of VBA / Macros Chapter â 82 (Userform Part-3)
Currency Converter Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another. The Userform we are goingâŚ
Read article âBasics of VBA / Macros Chapter â 81 (Userform Part-2)
Basics of VBA / Macros Chapter â 81 (Userform Part-2)
Userform and Ranges You can use a RefEdit control in Excel VBA to get a range from a user. The Userform we are going to create colors the minimum valueâŚ
Read article â