latest
VB.NET SQL Examples for Querying Databases Efficiently
Discover how to issue the most common SQL commands using VB.NET.
How to Send Emails From an Excel Spreadsheet Using VBA Scripts
Our code template will help you set up automated emails from within Excel using Collaboration Data Objects (CDO) and VBA scripts.
How to Use the For Each Loop in Excel VBA
Want to automate repetitive tasks in Excel using VBA? Learn how to use the For Each loop to efficiently manipulate data in your spreadsheets.
How to Use the Do-While Loop in Excel VBA
Want to automate repetitive tasks in Excel VBA? Learn how to use the Do-While loop to execute a set of actions repeatedly until a condition is met.
Learn to Automate Your Vlookups With Excel VBA
Take your Excel programming a step further by using the popular VLOOKUP function in your VBA code.
How to Insert a Picture Into a Cell Using VBA in Excel
You can easily insert images in your spreadsheets and manipulate them with macro code. Here's how to insert a picture into a cell using VBA in Excel.
Learn How to Automatically Create Pivot Tables in Excel With VBA
Pivot tables are a powerful data visualization tool, but they can be awkward to set up. Take the frustration out of this process with a VBA script.
How to Remove All Hyperlinks in a Word Document Using VBA
You can automatically remove all hyperlinks from your document by setting up a macro in Word. Here's how to do it easily.
How to Automatically Add Text to a Document’s Header in Microsoft Word Using VBA
Want to automate the process of adding text to a document's header in Word? Here's how you can use VBA to automatically add headers to Word documents.
The Excel VBA Programming Tutorial for Beginners
VBA is a Microsoft Office power tool. You can use it to automate tasks with macros, set triggers, and lots more. We'll introduce you to Excel visual basic programming with a simple project.
Understanding Excel Cells vs. Range Functions in VBA
Using the Range and Cells functions in Excel can get very confusing. Here's how you can make use of them in ways you probably never imagined, with the help of VBA
Can You Run Visual Basic 6 Apps on Windows 11?
Windows 11 has made major strides for the operating system, but can you run older Visual Basic 6 apps on it still?
How to Create and Design a VBA User Form
Forms allow you to add a user interface to your Office-backed VBA programs. Learn how to create one and discover which controls they support.
How to Create an Automated Data Entry Form in Excel VBA
Follow this tutorial to create a custom VBA-automated data entry form.
Top 9 Professional Sample Code Websites for Programmers
Looking to learn and create applications with example code snippets? Here are the best free code sample websites to start with.
How to Fit Your Excel Spreadsheet to Your Screen
Are you tired of resizing Excel spreadsheets to fit your screen? Here are three quick solutions that can make your spreadsheet much easier to view.
High-Level vs. Low-Level Programming Languages, Explained
What are high-level and low-level programming languages? How does it affect learning to write code? Here's what you need to know.
How You Can Make Your Own Simple App With VBA
Want to know how to make your own VBA application to solve problems? Use these tips to build your own VBA software.
4 Mistakes to Avoid When Programming Excel Macros With VBA
Simple code is vital for Microsoft Excel power users. But how can you make or safely exit a for loop using VBA in Excel?