Choose your language

Recursive Factorial VBA

Advanced Exercise

Statement

Create a function that calculates the factorial of an integer without using loops (including For Next, For Each, Do Loop, etc.).

Remember that in most cases there is more than one way to solve the exercise.

Hint: It is possible to call a function inside its code (creating what is called recursion).

Show Answer
Download exercise Download answer

INTRODUCTION

VBA Exercises

BASIC

VBA Formatting Text VBA Color Selected VBA Metric Converter VBA Do Loop Sum VBA Sum of Powers VBA Sort Array VBA Simple Loop VBA Harmonic Mean VBA Alternate Color VBA Even or Odd VBA First Capital Letter VBA Intersection VBA Ascending Order VBA Concatenate VBA Select Case VBA Columns to Lines VBA Making an Addition VBA Offset Resize VBA Search and Color VBA Current Region VBA Simple Email

INTERMEDIATE

VBA Message Box VBA Final Score VBA Factorial Function VBA Infinite Series VBA Count dollar bills VBA Prime Number VBA If Insert Cell VBA Text to Columns VBA Even and Odd VBA Ballot Box

ADVANCED

VBA Recursive Factorial VBA Hangman Game VBA HTML Email

SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2024 SuperExcelVBA | ABOUT

Protected by Copyscape