Excel File Recovery

How to Auto Adjust Combo Box or List based on Dynamic Data Ranges in Excel

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 »

How to Display Progress on the Status Bar of Your Excel

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 »

DataNumen CRM – A Free Customer Relationship Management System in Your Excel

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 »