We're going to create a general purpose Excel VBA login form, that can be used to display hidden worksheets to the end user of your application. The principles used here can also be used to login to any application that you create or used to authenticate against a database such as Sql Server or Access. Get the spreadsheet used in the tutorial above. Also … [Read more...] about How To Create An Excel VBA Login Form
VBA
How To Create A VBA Form In Excel
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
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 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