66% Off Microsoft Excel Value Bundle This is a beginner level tutorial, but I will assume you know how to do basic things like open the “Developer” pane. You can learn more about that in Excel Visual Basic #1: Getting Started. The Below Video has no Sound, it is […]
66% Off Microsoft Excel Value Bundle In this tutorial, I am going to show you how to duplicate sheets from a template sheet. This is aimed at someone who knows the basics of VBA. I assume you know how to do a lot of things already and I […]
66% Off Microsoft Excel Value Bundle Selenium Basic is an add-on library for Excel Visual Basic. I am positive there are a lot more uses than I know of, but what I know about it makes it well worth learning. You can use it to build fancy automated […]
66% Off Microsoft Excel Value Bundle My guest blog post on using Selenium Basic in Excel to automate web navigation, user text entry, and button clicking. Originally posted on The Hack Post. This is a more intermediate level tutorial on Excel Visual Basic, but a beginner tutorial for Selenium […]
This tutorial is a little more complicated than the prior three tutorials. It takes what you have learned in those, combines them and adds some additional features. If you haven’t done the prior tutorials and know nothing about VBA, you may want to do those first. The tutorials […]
This is the third part of the Excel Visual Basic tutorial series. It is recommended that if you are new to VBA, you begin with Excel Visual Basic #1: Getting Started. You can view all available tutorials on the Excel VBA Tutorials page. Take a look at the image below: The […]
In this tutorial, we will cover the basics of variables and decision structures. Then we will create a more advanced version of the simple message box created in the first tutorial. If you are unsure how to access the developer tab within Excel, please see the first tutorial […]
Below you will find two videos. The purpose of these videos is to show you how to gain access to the VBA development capabilities of Excel and to show you how to create your first “Hello World” application inside of Excel. I also provide written steps in case […]