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
All Articles
How To Consolidate Data From Multiple Workbooks In Excel VBA
There are two scenarios for consolidating data from multiple Excel workbooks using vba. You have complete control over the files to be consolidated or merged.This could be because you’re starting from scratch and developing a system to be used by your team going forward. You don’t have control over the input files (spreadsheets) to the consolidation process.Perhaps the … [Read more...] about How To Consolidate Data From Multiple Workbooks In Excel VBA
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 Create a LibreOffice Or OpenOffice Base Split Database
In this tutorial I'm going to create a LibreOffice split database and import some csv text files that have been exported from a different database system. First Create The Split Database There are many ways to import data into LibreOffice base, I'll start off here with the most simple - if not the most robust way, which is importing data via the user … [Read more...] about How To Create a LibreOffice Or OpenOffice Base Split Database
What Does Excel Sumif and Sumifs Do?
Excel's Sumif and Sumifs allows you to query your tabular data for numerical answers to your questions like what was our sales or costs for January last year?Or in the case of this example here what was the total volume traded on the NYSE for ticker "abev"? The YouTube video above takes you through a practical example of sumif and sumifs using the tabular … [Read more...] about What Does Excel Sumif and Sumifs Do?