The problem I recently had a plea for help from a client for whom I was running an Excel training course. They wanted to highlight dates an Excel worksheet in various ways - red for dates in the past, amber for dates in the next week, yellow for dates a couple of weeks away, [...]
Excel gets maths wrong sometimes... Do you use Excel regularly? And do you trust that if it says something's true, then it's probably true? Perhaps not in the area of global politics, or issues around faith and ethics, but you can rely on it when it comes to maths, right? We're not talking high-level, professor [...]
Get over the limitations of the built-in CONCATENATE function in Excel.
In this post we take a look at writing an alternateive to Excel's concatenate function, which both overcomes the limit on the number of values that can be concatenated, and also allows a delmiter to be specified, such as a comma, beteween values.
Creating dynamic forms with Conditional Formatting
In this video tutorial we take a look at using conditional formatting to make Excel forms dynamically respond to user entries.
For example, display "Additional info" fields when users select a particular value, or display multiple sections based on user input elsewhere.
The InputBox is one of the most commonly called functions in the whole of VBA. Whether you're writing a complete database application in Microsoft Access, or just adding bit of functionality to your Microsoft Excel workbooks, the odds are that you won't do much coding before you make your first call to the InputBox function.
So, I thought I'd dedicate this post to getting a little more from the InputBox - particularly in Excel, but also in Access.