Blogs from Wise Owl on General in VBA macros

Showing blogs 1-9 (out of 9)

Disabling Screen Updates in Excel VBA

Posted by Andrew Gould on 26 November 2015

You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.

Tags:   VBA macros | General    |    Writing VBA | Other

How to create autoshapes, lines and connectors in VBA macros

Posted by Andy Brown on 25 January 2014

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:   VBA macros | General    |    Writing VBA | VBA tutorial

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012

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 VBA | Other

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012

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:   VBA macros | General    |    Writing VBA | VBA tutorial

Collections, objects, methods and properties in Excel VBA

Posted by Andy Brown on 09 November 2011

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

Tags:   VBA macros | General    |    Writing VBA | VBA tutorial

Excel VBA training courses: classroom and online

Posted by Andy Brown on 16 August 2011

As well as running introductory and advanced VBA training courses in the UK for small groups, 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!

Tags:   VBA macros | General    |    Writing VBA | VBA tutorial

Introduction to Visual Basic for Applications (VBA)

Posted by Andrew Gould on 01 July 2011

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    |    Writing VBA | Other

Using sheet codenames in Microsoft Excel VBA

Posted by Michael Allsop on 01 June 2011

Do your macros keep falling over due to users renaming their worksheets in Excel? Read this article to find out if sheet codenames could be the solution you need.

Tags:   VBA macros | General    |    Writing VBA | Other

Commenting out code in VBA

Posted by Andy Brown on 28 April 2011

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

Tags:   VBA macros | General    |    Writing VBA | VBA tutorial
This page has 0 threads Add post