Blogs from Wise Owl on General in VBA macros

Showing blogs 1-18 (out of 18)

Flappy Bird in Excel VBA Part 13 - Playing Sounds

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial explains how to add sounds to the game using a Windows API function.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 12 - Managing Game State

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial implements a state system to make it easier to determine what actions to perform each time the game updates.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 11 - Detecting Collisions

Posted by Andrew Gould on 24 April 2014 | no comments

In this part of the tutorial you'll learn how to make the game detect collisions between the bird and the obstacles.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 10 - Creating Obstacles

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial shows you how to add obstacles to the game and how to make them move across the screen.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 9 - Creating the Game Sheet

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial explains how to generate a game worksheet using code to define the playing area.

Tags:   VBA macros | General

How to create autoshapes, lines and connectors in VBA macros

Posted by Andy Brown on 25 January 2014 | no comments

You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Advice on how to scrape tables of data or HTML from webpages using VBA

Posted by Andy Brown on 13 January 2014 | no comments

You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

How to use environment variables like USERNAME in VBA

Posted by Andy Brown on 25 November 2013 | no comments

You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012 | 1 comment

Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.

Tags:   VBA macros | General

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012 | no comments

In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Passing arguments to subroutines in VBA

Posted by Andy Brown on 09 February 2012 | 1 comment

To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Error-handling and error trapping in Excel Visual Basic macros

Posted by Andy Brown on 29 November 2011 | no comments

What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Debugging macros in Excel Visual Basic / VBA

Posted by Andy Brown on 25 November 2011 | 1 comment

This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Collections, objects, methods and properties in Excel VBA

Posted by Andy Brown on 09 November 2011 | 9 comments

Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!

Tags:   Excel | Excel Visual Basic    |    VBA macros | Excel Visual Basic    |    VBA macros | General

Using the InputBox Function in VBA Macros

Posted by Andy Brown on 03 October 2011 | 1 comment

The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!

Tags:   Excel | Excel Visual Basic    |    VBA macros | General

Using MsgBox to Display Messages in VBA Macros

Posted by Andy Brown on 28 September 2011 | 2 comments

The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.

Tags:   Excel | Excel Visual Basic    |    VBA macros | Excel Visual Basic    |    VBA macros | General

Introduction to Visual Basic for Applications (VBA)

Posted by Andrew Gould on 01 July 2011 | 17 comments

If you've heard people in your office talking about macros or VBA but don't understand what they mean, this blog series will make everything clear. It's an introduction to the most basic skills you'll need to start creating your own programs in any of the Microsoft Office applications.

Tags:   VBA macros | General

Commenting out code in VBA

Posted by Andy Brown on 28 April 2011 | no comments

Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA.

Tags:   Excel | Excel Visual Basic    |    VBA macros | General