Pyramid Volume Calculator
Posted Date Unknown 0 Comment


This article is about a project called “Pyramid  Volume Calculator”, which is done in Microsoft Excel, with the help of Macro. A Macro is a series of commands and functions those are stored in a Microsoft Visual Basic Module and it could be run wherever you need to perform a task. With the help of Macro and Visual Basic Commands, this project will help you to calculate the volume of a pyramid.

Screen Shot


This article assumes that you have some basic knowledge in Microsoft excel and Visual Basic.

Using the Project

Before doing or editing a project in Macro you should activate macro and explore the developer tab first.

1.    Select the “Microsoft Office” button and  click “Excel option”
2.    Select the option “Advanced” and choose “Show developer tab” option.
3.    Select “Trust Centre”, click “Trust Centre Settings” and choose Macro Settings.
4.    Select “Enable all macros” and click “Trust Access to VBA project object model” option.
5.    Select OK button.

Run Macro: go to the developer tab and select Macro. Run macro by clicking the “Run” button. Edit macro: select “Step into” button, the desired VBA code will be opened for editing the selected macro.

Points of Interest

Some of the basic features used in this project are: Macro, VBA, Module,Workbook, Sheet, Cell,Developer Tab,Insert Controls, Mathematics,Microsoft Excel 2007.


01/04/2012 - Article Created

Please download the source code from the below link and try experimenting with the source code.

See All Responses Below...
Message Rating
Posted on:
Please Login to Post Your Comments
Name (Max. 100 characters)
Please post your comments here
Select Language
Attach File(Max. Size: 2 MB)
A few simple rules when posting your Comments,
  1. Please post only answers relevant to the topic of discussion.
  2. Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site.