The following article shows how to mark out and interrogate a calendar with the mouse.
*In the real world, we’d open a form to read and write meaningful diary entries to a database. This exercise simply reveals the mechanics of right_clicking, and finds the details from the worksheet itself.
Before we begin, a few words of explanation about the spreadsheet, a working model of which can be found here.
The Process
Clicking on a cell within the grid will highlight that cell and change...
Read more »
We’ve all seen spreadsheet names and addresses with a mix of formats like JAMES JONES, sARAH bERNARDT or clint eastwood, all of which look amateurish on a report. This article shows how to standardise text in the proper way in a worksheet.
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 Excel file can be found here
In this exercise we’ll build a...
Read more »
Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server.
A more efficient way of doing this, particularly if the database is at a remote location and there’s a lot of traffic involved, is to do the work ‘server-side’. This exercise calls a stored procedure from Excel to categorise employees into age-ranges according to their dates of birth (i.e. 18-25 years, 26-35 years, etc.), without a...
Read more »