Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data. This article examines how to do this automatically.
It is assumed 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”.
A professional way of displaying combo boxes is to...
Read more »
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 »