- Home
- vba
Excel VBA Macros : How To Change Text In A Cell
The Story So Far… Our series of posts on Excel VBA Macros began with these posts: Introduction Setting up Excel for VBA Recording your first Macro (and challenge question) Answer to challenge question Reading your first Macro If you have not already read them, I would suggest going through them now before continuing. The last […]
Continue readingExcel VBA Macros : Understanding Our First Macro
The Story So Far…. If you have been following these posts so far, you should have read Introduction Introduction 2 & Setting Up Excel For Macros Recording A Macro & Challenge Question Answer To Challenge Question You should have a file saved from the earlier posts where you recorded a macro and ran it using […]
Continue readingExcel VBA Macros : Answer To Challenge Question 1
The Challenge In the last post (click here) we recorded a macro. This macro took our basic report….. and automatically formatted the basic report to a layout that we needed….. However, when we added in an extra row and ran the macro, it didn’t give us what we might have expected….. Your challenge was […]
Continue readingExcel VBA Macros : Recording Your First Macro
This post will give you more of an introduction to Excel VBA Macros and you will be recording your first macro. After recording the macro, we will then look at the code generated and start breaking it down, this will be the start of your adventures coding macros!! The Story So Far….. The following […]
Continue readingExcel VBA Macros : Introduction
If you spend a lot of time working with Office applications such as Excel, Word, PowerPoint, etc. there is a good chance that you do repetitive and monotonous tasks, probably without thinking about it or questioning it. Over the next few posts I will talk about Excel VBA Macros and the first examples will look […]
Continue readingMaking Office work for you with VBA Macros
Don’t be a slave to your computer!! Introduction to VBA Macros You may have heard references to VBA or Macros in the past, but what are they? VBA VBA, or Visual Basic for Applications, allows users to increase and improve the functionality of some programs by making more use of menus, tool-bars and options already […]
Continue reading