Format Percentages in VBA
When we apply the percentage number format to cells with values, the values are multiplied by 100 to convert them to percentages. This…
Category: vba
Use VBA Function in Excel Formula
Visual Basic for Application (VBA) is a fantastic tool for automating work in Excel. It allows us to program our work and customize…
Hide and Unhide Rows or Columns Using VBA
Before we send out by email or print a particular Excel workbook we have been working on, we may want to hide specific…
Sort Data by Date in VBA
Everything that you do in Excel, manually or using formulas, can be done in VBA. People are sometimes reluctant to use VBA as…
Loop Through Array Using VBA
If you ever used Visual Basic for Applications (VBA) in any form, especially in Excel, you are aware of the advantages and benefits…
Convert Currency To Text In VBA
You are probably aware that Excel has amazing options for formatting data. We can present what we want in a lot of ways….
Get Value From Listbox Using VBA
With Excel and VBA especially, options for everyone are virtually limitless. In VBA, users can create Macros, UserForms, and ClassModules. One of the…
Get Textbox Value in VBA
The textbox is a term that you should probably be familiar with, especially if you ever used any Office program. In Excel, textboxes…
Create and Save New Workbook in VBA
Visual Basic for Applications (VBA) allows us to automate every aspect of our work in Excel. This can relate to any level that…
Insert an Array Formula Using VBA
An array formula performs many calculations on one or more items in an array. This tutorial shows how to insert a multi-cell and…
