Wise Owl Training - VBA macros blogs (page 3 of 4)

Showing blogs 41-60 (out of 64)

How to choose files and folders in VBA

Posted by Andy Brown on 13 January 2012 | 1 comment

To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

Linking to the Microsoft Scripting Runtime library

Posted by Andy Brown on 13 January 2012 | no comments

In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!

Creating references programmatically in VBA

Posted by Andy Brown on 03 January 2012 | no comments

Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.

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

Using CreateObject and GetObject to create references

Posted by Andy Brown on 09 December 2011 | 1 comment

Although it's usually easiest to create references to other applications using the Tools/References menu as described in an earlier blog, you can use the method shown in this blog instead.

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

Referencing Word and other applications in Excel VBA

Posted by Andy Brown on 05 December 2011 | 6 comments

Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software

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

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

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!

Looping in Visual Basic for Applications macros

Posted by Andy Brown on 15 November 2011 | 5 comments

There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.

Conditions in Visual Basic for Applications - IF and SELECT CASE

Posted by Andy Brown on 15 November 2011 | no comments

This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.

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

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 VBA training courses: classroom and online

Posted by Andy Brown on 16 August 2011 | 5 comments

As well as providing introductory and advanced VBA training, we've also published this online training course teaching how to code macros using Visual Basic for Applications (VBA) 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!

Using VBA in Microsoft Project to Set Up Unusual Calendars

Posted by Andrew Gould on 01 July 2011 | no comments

Setting up a pattern of working time in a Project calendar is simple enough when your week runs from Monday to Sunday, but when you have an unusual working pattern setting up the calendar is a pain! This article explains how to use VBA to create a detailed calendar at the click of a button!

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

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!