Category Archives: Visual Basic for Applications

Excel: How to Create a Custom Function

Excel has lots of built-in functions that do everything from summing up a column or row of numbers to loan repayments, statistics, engineering, trigonometry and so much more. Every now and again someone asks how they can create their own … Continue reading

Posted in Excel, VBA, Visual Basic for Applications | Tagged , | Leave a comment

VBA: Using the IF Statement

The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications | Tagged , , , , | 1 Comment

VBA: Understanding Variables

If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, PowerPoint, Uncategorized, VBA, Visual Basic for Applications, word, word 2010 | 1 Comment