EXCEL + BLOGS
VBA MACROS BLOGS
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (2)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (9)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on General in VBA macros
Showing blogs 1-9 (out of 9)
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.
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!
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.
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.
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!
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.
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.