Excel Solutions

How to Create a vCard (.vcf File) Reader with Excel VBA

Have you ever wanted to import contact details from VCF data in to an Excel sheet? Follow this article and create your own VCF reader that would import data from your VCF files into Excel worksheets Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI Let’s prepare the GUI for our VCF reader application. On Sheet1 we have to create a...

Read more »

How to Create a Football Pitch and Ball Pass Logger with Excel VBA

Certain Football fans go a step further and track each ball pass on the field and analyze the game. With this article, you can easily create a software in Excel with which you can easily track each ball pass during a Football match Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's prepare the GUI We need two sheets. The first sheet should be named as...

Read more »

How to Control Data Capture with a VBA Form in Excel

User capture into a spreadsheet is difficult to police; the entry point could be anywhere, and even locking of some cells provides no focus on the part of the user. A User Form with validation can provide an orderly channel for data capture into a spreadsheet. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. Objective To produce the following form, which writes...

Read more »