Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Excel Visual Basic for Applications blogs

Showing blogs 1-20 (out of 23)

Flappy Bird in Excel VBA Part 7 - Creating Sprites

Posted by Andrew Gould on 11 April 2014 | no comments
This part of the tutorial describes how to draw simple images using a worksheet as the canvas. You'll also see how to include the images in the game.
This part of the tutorial describes how to respond to keys pressed by the player. You'll learn about the Application.OnKey method and the GetAsyncKeyState Windows API function.
This part of the tutorial adds a basic menu system with ActiveX command buttons to start and stop the game.

Flappy Bird in Excel VBA Part 4 - The Game Timing Loop

Posted by Andrew Gould on 11 April 2014 | no comments
This part of the tutorial describes how to set up a timing loop which allows the game to update continuously.
This part of the tutorial describes how to make use of Windows API functions to extend the power of Excel VBA.

Flappy Bird in Excel VBA Part 2 - Basic Workbook Setup

Posted by Andrew Gould on 11 April 2014 | no comments
This part of the tutorial describes how to setup a basic workbook ready for you to start coding the Flappy Owl game.

Flappy Bird in Excel VBA Part 1 - Introduction

Posted by Andrew Gould on 11 April 2014 | no comments
This part of the Flappy Bird in Excel VBA Tutorial introduces you to the Flappy Owl game and provides download links and instructions to get it running in Excel on your machine.

Flappy Bird in Excel VBA - Tutorial Index

Posted by Andrew Gould on 11 April 2014 | no comments
This is the main index page for the Flappy Bird in Excel VBA tutorial. Here you can find links to all of the articles which comprise the tutorial.

How to loop over enumerations in VBA

Posted by Andy Brown on 07 November 2013 | no comments
A short blog explaining how to use Visual Basic for Applications to loop over enumerations.
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Tags:   VBA macros / Excel Visual Basic   |   Excel / General

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013 | no comments
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Tags:   Excel / Charts   |   VBA macros / Excel Visual Basic

Event-handling macros in Excel Visual Basic

Posted by Andy Brown on 22 November 2011 | 2 comments
Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!

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!

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.

Variables and Constants in Excel Visual Basic

Posted by Andy Brown on 05 September 2011 | 6 comments
This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.

Excel Macros Tutorial | Excel VBA training course

Posted by Andy Brown on 16 August 2011 | 5 comments
Use this free online training in Excel Visual Basic for Applications (VBA) to learn how to program macros within Excel. The tutorial covers everything from basic recording through to creating classes - something for everyone!

Relative Selection using Excel VBA Macros

Posted by Andy Brown on 16 August 2011 | no comments
This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods.

Selecting Cells using Excel VBA Macros - Absolute

Posted by Andy Brown on 11 August 2011 | no comments
This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!

Assigning short-cut keys to VBA macros in Excel

Posted by Andy Brown on 01 July 2011 | no comments
This short blog shows how to assign short-cut keys to macros in Excel 2010, Excel 2007 and Excel 2003. So if you've written a whizzy macro in VBA and want to be able to run it with a single keystroke combination, read on!
1-20   21-23  

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.