Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

VBA macros blogs

Showing blogs 21-40 (out of 63)

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
You can use VBA to talk to Internet Explorer, providing that you understand the structure of the web page you're talking to. This blog shows how to do this!
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | no comments

It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink.  This blog explains how you might go about creating an event sink.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes
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

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012 | 4 comments
If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.
Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012 | 5 comments

Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers.  It's difficult, but fun - and this multi-part blog will guide you along the way.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012 | 2 comments

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

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

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012 | 4 comments

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events.  This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012 | no comments

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012 | no comments
Learn how to create your own custom dialog boxes in VBA, using UserForms.  This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).
Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012 | no comments
On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.
Tags:   Excel / Excel Visual Basic   |   VBA macros / Functions

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012 | no comments
You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012 | no comments
Excel and other MS Office applications make extensive use of enumerations - and you should too!

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

Linking to ADO databases with VBA

Posted by Andy Brown on 06 February 2012 | 1 comment
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Copy, rename, delete and move files and folders

Posted by Andy Brown on 23 January 2012 | 1 comment
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.

Reading and writing to/from a text file using TextStreams

Posted by Andy Brown on 13 January 2012 | 2 comments
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.

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.
1-20   21-40   41-60   61-63  

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