Not knowing how long a program will run makes us restless. The program might have hung, or might finish in five minutes – or maybe in two hours. This article looks at keeping the anxious user informed in real-time via the Status Bar.
This 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”.
The exercise will look like this, using the example file found here.
The...
Read more »
A happy customer is very hard to attain and retain. If you are struggling to maintain your Clients' database, with this tool you can easily add new Client info, edit or delete existing Client info and retrieve them quickly.
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
Create 3 sheets and name it as "Entry", "Client" and...
Read more »
Many small offices lose a lot of money as they do not have a proper tool to track their employee‘s timesheet. With Excel, we can build an automated timesheet tracker. Employees have to sign in and sign out to capture hours worked for a day.
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 just need a single sheet in the workbook....
Read more »
