Excel’s Concatenate function without limits!

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.

Advanced Excel conditional formatting video tutorial (part 2)

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 Function, the InputBox method, and using strptr

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.