Excel VBA Articles

Visual Basic for Applications (VBA) is the simple programming language used within Excel to develop macros and complex programs.

VBA is functionally rich and extremely flexible.

Excel Samples

• Calculating Net Present Value (NPV)
• Calculating Internal Rate of Return (IRR)

Excel VBA Code Samples

• Enable Macros in Excel
• Range Object in VBA
• Using Intersection to Create a Range in Excel VBA
• Screen Updating using VBA in Excel
• Save Workbook as New File using VBA in Excel
• How to Avoid Incorrectly Typing the Name of an Existing Variable in VBA Script?
• How To Store Current Range Selection using VBA in Excel?
• Using Message Box (MsgBox) in Excel VBA
• Define a Position of MessageBox using VBA in Excel
• Custom Message Box Buttons using Hooking in Excel VBA
• Using InputBox Method in Excel VBA
• Bit Operations in Visual Basic (Excel VBA)
• Bit Shifting Function in Visual Basic (Excel VBA)
• Disable Alert (Warning) Messages in Excel
• IE (Internet Explorer) Automation using Excel VBA

SmartDel Macro

• SmartDel Macro
• Assign Hotkey to SmartDel Macro using Excel VBA
• Build SmartDel Excel Add-In