MakeUseOf - Visual Basic Programming

How to Send Emails From an Excel Spreadsheet Using VBA Scripts

Tina Sieber — Tue, 25 Apr 2023 18:00:16 GMT

To send emails from Microsoft Excel only requires a few simple scripts. Add this functionality to your spreadsheets, and you can accomplish much more in Excel.

How to Use the For Each Loop in Excel VBA

Sahil Kapoor — Mon, 17 Apr 2023 16:30:17 GMT

Loops and VBA go together, and for a good reason too. When dealing with Microsoft Office objects like workbooks, worksheets, and ranges, loops can help you toggle between each of them with relative ease.

How to Use the Do-While Loop in Excel VBA

Sahil Kapoor — Wed, 29 Mar 2023 16:30:17 GMT

Loops are an integral part of any coding language, and you can automate plenty of repetitive tasks, by using a variety of loops, depending on the language at hand. Excel’s VBA is no different from the others, since it offers a series of looping options, each serving a different purpose.

Learn to Automate Your Vlookups With Excel VBA

Sahil Kapoor — Fri, 24 Feb 2023 20:30:17 GMT

Vlookup is an essential function within Excel and has become a vital part of data processing. It provides some of the functionality you might usually associate with a full-blown database.

How to Insert a Picture Into a Cell Using VBA in Excel

Amir M. Bohlooli — Tue, 01 Nov 2022 20:45:14 GMT

Visual Basic for Application, VBA for short, is a form of Visual Basic 6 integrated into Microsoft Office programs. Through coding, VBA allows you to automate tasks in Office programs, including Excel. In some cases, you can even add new features to Excel using VBA.

Learn How to Automatically Create Pivot Tables in Excel With VBA

Advait Singh — Thu, 13 Oct 2022 13:00:14 GMT

Pivot tables in Excel are pivotal in making data easier to understand and comprehend. A pivot table can condense and crunch data into meaningful structures. MS Excel users have widely adopted them within the data industry.

How to Remove All Hyperlinks in a Word Document Using VBA

Amir M. Bohlooli — Wed, 31 Aug 2022 20:00:14 GMT

Removing hyperlinks in Word is easier than even adding them, but this cinch can get rather tiring when done in great quantities. VBA is a powerful tool in Office apps, including Word, that allows you to automate nearly any task.

How to Automatically Add Text to a Document’s Header in Microsoft Word Using VBA

Amir M. Bohlooli — Thu, 25 Aug 2022 13:30:14 GMT

Headers are a great place for introducing your Word document, and they're also easy to use. You just need to double-click the header and type, right? Easy as it is, just like anything else, this task can get rather monotonous and annoying if you have to add the same header for multiple documents in a row.

The Excel VBA Programming Tutorial for Beginners

Amir M. Bohlooli — Mon, 01 Aug 2022 20:00:14 GMT

Visual Basic for Applications (VBA) is the Microsoft Office programming language that allows you to create macros, add a message box, execute code inside a document in response to a trigger, and much more. With VBA, you can supercharge your Excel spreadsheets and go beyond mere Excel functions.

Understanding Excel Cells vs. Range Functions in VBA

Ryan Dube — Wed, 23 Mar 2022 21:30:14 GMT

Excel is powerful. If you use it a lot, you probably already know a lot of tricks using formulas or auto-formatting, but making use of Ranges and Cells function in VBA, you can take your Excel analytics to a whole new level.

Can You Run Visual Basic 6 Apps on Windows 11?

Shan Abdul — Wed, 23 Mar 2022 18:15:14 GMT

The number of VB6 users has declined over the last decade, but a small proportion of developers still use VB6 apps.

How to Create and Design a VBA User Form

Gaurav Siyal — Mon, 21 Mar 2022 10:00:13 GMT

User forms are an integral part of VBA programs, and it’s important to design them correctly to ensure correct behavior. User forms allow you to add an intuitive interface to your spreadsheets, for user interaction.

How to Create an Automated Data Entry Form in Excel VBA

Gaurav Siyal — Mon, 28 Feb 2022 18:30:13 GMT

Visual Basic is an excellent language for automating repetitive tasks in Excel. Imagine taking your automation up a notch by creating highly functional user forms that also look tidy to the end-users.

Top 9 Professional Sample Code Websites for Programmers

Ian Buckley — Wed, 29 Dec 2021 15:10:22 GMT

Most programmers are not just desktop programmers, web programmers or scripting gurus—instead, they're often all of the above. Knowing where to find free samples of code online can help you learn and create applications with these working code snippets.

How to Fit Your Excel Spreadsheet to Your Screen

Ryan Dube — Sun, 12 Dec 2021 21:30:12 GMT

Excel is a powerful tool for so many things, but having to resize the sheet to fit your screen every time you open a file can be a major pain. If you often find yourself wondering, “how do I make my Excel spreadsheet fit my screen”, here are three quick solutions that can make your spreadsheet much easier to view.

How to Create a VBScript ODBC Connection

Wini Bhalla — Tue, 27 Jul 2021 13:15:38 GMT

One of the most common uses for VBScript is to connect databases. Believe it or not, the process is relatively easy, and even beginners can establish a connection with ease. Here's everything you need to know on how to create a VBScript ODBC Connection.

High-Level vs. Low-Level Programming Languages, Explained

Anthony Grant — Wed, 10 Jun 2020 16:00:00 GMT

Programming languages are separated into two classes. They can be either high-level languages or low-level languages. Each type of programming language has its own purpose. Learning the difference between the two is an important step to figuring out which one to use.

How You Can Make Your Own Simple App With VBA

Anthony Grant — Wed, 22 Jan 2020 19:00:03 GMT

Visual Basic for Applications (VBA) is a remarkable language. Built into Microsoft Excel, this language can be used to program apps right inside an Excel worksheet.

4 Mistakes to Avoid When Programming Excel Macros With VBA

Anthony Grant — Mon, 23 Dec 2019 17:00:00 GMT

Microsoft Excel is already a capable data analysis tool, but with the ability to automate repetitive tasks with macros by writing simple code in Visual Basic for Applications (VBA) it's that much more powerful. Used incorrectly, however, VBA can cause problems.

Use Macros in Excel on Mac to Save Time and Do More

Michael McConnell — Tue, 20 Feb 2018 23:00:00 GMT

Excel on the Mac has not always been the same powerhouse it was on Windows. Macros really wouldn't work unless they were created exclusively for the Mac.

How to Hide and Unhide Sheets in Excel

Brad Jones — Wed, 20 Dec 2017 18:00:00 GMT

Need to tidy up an Excel document? Here's how to hide one or more sheets.

How to Integrate Excel Data Into a Word Document

Ryan Dube — Fri, 25 Aug 2017 23:01:15 GMT

During your work week, there are probably lots of times that you find yourself copying and pasting information from Excel into Word, or the other way around. This is how people often produce written reports based on data that’s accumulated and updated in an Excel spreadsheet. In this article, I’m going to dive a little more into the background VBA scripting that allows you to actually program connections between data in Excel and Word.

How to Build a Custom Excel Toolbar of VBA Macros

Brad Jones — Thu, 27 Jul 2017 18:00:00 GMT

Ready to supercharge your Excel productivity? A custom toolbar can do just that.

How to Recover an Excel VBA Password

Brad Jones — Mon, 26 Jun 2017 23:00:00 GMT

Stuck with a VBA document that's password protected? Here's how to pick the lock.

How to See All Your PC Information Using a Simple Excel VBA Script

Ryan Dube — Wed, 24 Jun 2015 18:00:00 GMT

Have you ever needed to know your computer's CPU or memory details, serial or model number, or installed software versions, but weren't sure where to look? With just a bit of simple code in Excel, you can extract a whole library of your Windows PC information.

How To Automate Firefox Or Chrome With Excel VBA And Selenium

Ryan Dube — Thu, 17 Oct 2013 21:00:00 GMT

The key to automation is doing things faster and easier than you've ever done before. So what takes you a long time to do? What part of your workload would like to automate?

Add A Chart To A Microsoft Document With Office Web Components

Ryan Dube — Fri, 10 Aug 2012 21:00:25 GMT

Isn't it amazing how something as simple as creating a chart can feel so complicated sometimes? Whether you're using Excel, Word, Powerpoint or Access - sometimes it would be nice to just insert a quick chart with a bunch of data without having to do a whole lot of configuring and messing about.

Monitor If Your VBA Apps Are Running With This Slick Script

Ryan Dube — Fri, 20 Jul 2012 21:01:22 GMT

Let me paint a scenario for you. Let's say that you've created a scrolling Powerpoint slideshow that you want to display permanently on a large TV display at work. Or, maybe you have an Excel application that includes an entry form for your workers to type information into a database.

Pass Any Information Between VBA Applications Using The Clipboard

Ryan Dube — Fri, 17 Feb 2012 22:00:40 GMT

Just when I thought that I was finished with my latest batch of VBA tips and tricks, I discovered yet one more really cool technique that anyone can use to easily pass information between two applications that utilize VBA as a back-end scripting language.

How To Export Your Outlook Tasks To Excel With VBA

Ryan Dube — Fri, 10 Feb 2012 22:01:28 GMT

Whether or not you are a fan of Microsoft, one good thing that can be said about MS Office products, at least, is how easy it is to integrate each of them with one another. Just think of the power that comes from having incoming emails automatically generating new tasks or new calendar appointments, or having a completed task automatically email your boss with the updated status report from the task description.

How To Make Your Own Basic Internet Browser Using VBA

Ryan Dube — Wed, 14 Dec 2011 18:31:10 GMT

When you really stop to think about it, an Internet browser in its simplest form isn't really that impressive an application. I mean, yes, the Internet is amazing by anyone's standards. The concept of linking so many of the world's computers and mobile devices within this massive network, that is epic. But the concept of transferring a text file with special code in it, and displaying that transferred text onto the computer screen - that's really not a big deal.

Create A Freaky Possessed Computer With Windows Script For Halloween

Ryan Dube — Fri, 28 Oct 2011 12:01:50 GMT

There are a lot of fun pranks you can play on your friends with a computer. You've probably seen all of those creepy YouTube videos that people forward to each other for a good scare. Not long ago, Justin covered a few really funny ways to prank your parents with a computer too. All of those ideas are fun, but this year, how about creeping out your friends a bit with your very own programming skill?

4 Great Websites To Make You A Visual Basic Guru

Ryan Dube — Sun, 31 May 2009 22:00:09 GMT

For the first few years of my engineering career, I spent a lot of time writing Visual Basic based GUI applications for automated factory machines. These were the sort of VB applications that were very difficult to test, because for the most part the users consisted of moderately educated folks who had a hard time using a mouse, let alone clicking on the screen and entering information. Inevitably, no matter how much I tested these applications, one of these operators would do something that would bring the application crashing to its knees. Very quickly, I learned the value of reusing thoroughly tested Visual Basic code. Otherwise, if you start from scratch every time, you're bound to make new mistakes all over again.