We’re going to create a simple Excel vba form, that covers most of the concepts that you'll need to get up and running fast with your form creation in Excel VBA. The YouTube video tutorial below will take you through these concepts in more detail so lets get started. The result of this process will be a simple form with a text box for country and a text box … [Read more...] about How To Create A VBA Form In Excel
Excel VBA Macros
How To Make An Excel VBA Listbox Act Like A Grid
The Problem You're writing an Excel VBA Front end to some sort of system, it could be an Access, Sql Server or Oracle database, or some text files you're consolidating from third party data sources. You want to incorporate a Grid into your vba form so that it behaves similar to a Microsoft Access form and sub form relationship or any other slick third … [Read more...] about How To Make An Excel VBA Listbox Act Like A Grid
How To Find The Last Row In an Excel VBA Range
You are adding data on a consistent basis to your spreadsheet, and you need to have a macro that references the last row that was just added to your Excel spreadsheet data range or table. This article and associated video will show you how to do just that. Fig 1 So similar to "Fig 1" above you would like to reference row 14 of the table and possibly iterate over each … [Read more...] about How To Find The Last Row In an Excel VBA Range
How To Resize A Named Range In Excel VBA
To resize a named range in Excel VBA it's best to get an object reference to the range and then use the Excel VBA resize method to resize the range. With the resized range object you then set it's name property to the range name that you want resized. Excel will behind the scenes delete the old range name and replace it with the one you have just created. The spreadsheet … [Read more...] about How To Resize A Named Range In Excel VBA
How To Copy A Range Of Cells In Excel Using VBA
There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA