Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

WRITING RECURSIVE PROGRAMS IN VBA

Part one of a four-part series of blogs

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.

  1. Recursive Programming (this article)
  2. Using Recursion to Display the Contents of a Folder
  3. Using Recursion to Show Hierarchical Breadcrumbs
  4. Using Recursion to Solve Factorials

This blog is part of our Excel VBA tutorial series of blogs (consider also booking on one of our Visual Basic for Applications courses).

Posted by Andy Brown on 20 February 2012 | no comments

Recursive Programming

The dictionary definition of Recursion says it all:

Recursion (n.) - see under "Recursion"

And if you didn't get (or like) that joke, here's a real definition: recursive programming is when you write a program which calls itself. 

In practice there are few occasions when you'll actually use recursion - but when you do need it, it's nearly indispensable! 

The examples this blog will show are:

Example Notes
Folder contents Recursively looping over folders and subfolders
Creating breadcrumbs Creating menu breadcrumbs for hierarchical data
Calculating a factorial Calculating the factorial of a number

Of these, it would be much harder to write the first two examples without using recursion.

 

WRITING RECURSIVE PROGRAMS IN VBA

Part one of a four-part series of blogs

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.

  1. Recursive Programming (this article)
  2. Using Recursion to Display the Contents of a Folder
  3. Using Recursion to Show Hierarchical Breadcrumbs
  4. Using Recursion to Solve Factorials

This blog is part of our Excel VBA tutorial series of blogs (consider also booking on one of our Visual Basic for Applications courses).

Comments on this blog

This blog currently has no comments.

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