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…
Category: vba
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…
Create a New Sheet in VBA
Many times, we need to add a new sheet to a workbook. You can use Excel VBA or the keyboard shortcut to add…
Save Excel Worksheet as CSV with VBA
Visual Basic for Applications (VBA) is a great tool for the automatization of our work. It can also be used to manipulate any…