This section contains a whole host of Excel VBA routines, techniques and code that don’t really warrant having a page of their own but are very useful none the less. Whilst these routines have been tested in Excel, many of them will also work in the other VBA enabled Office applications exactly as they are, […]
A question we’re often asked is “How do I change the sound the Outlook plays when I get a new E-mail? I’ve looked in the options for Outlook but it’s no where to be seen.” You can’t find this option in Outlook because it’s not there, but it is easy to change, as it’s actually […]
For this part of the tutorial you will need the workbook you created in part 1 (Click here to go to part 1) Once you have created your macro you may never need to make any changes or enhancements, but that’s a pretty rare case. There are only really two options for changing your macro, trashing […]
Excel is a great application for manipulating numbers, and creating calculated results based on different sets of data. One of the most powerful and useful features of Excel is the ability to create macros, which are small ‘programs’ which repeat a pre-programmed series of commands to achieve a specific result. Associated with macros is VBA […]
Microsoft Excel contains a useful feature for allowing users to add a comment to a spreadsheet cell, which can be used to provide instructions to other people who may use the sheet. Cells with comments are denoted with a small red triangle in the top right corner, which then displays the comments box when the […]
If you develop solutions for other people using Excel as platform you will almost certainly have been in a situation where a user has (accidentally?) managed to mess things up by trying to change something they shouldn’t. In all good software solutions, the users should only be able to edit the parts they need to, […]
It doesn’t take most regular Excel users very long to get used to the alphanumeric referencing system for cells such A4, C8, BA27 etc, and this is fine when constructing fairly small and simple spreadsheets. However once workbooks and their worksheets become larger than just a few cells, trying to remember which number was in […]
Microsoft Excel has two types of cell reference – Absolute and Relative, and an understanding of how these references differ and work can help the spreadsheet designer to save vast amounts time when compiling their spreadsheet, especially when they are copying formulae or worksheets around a workbook. To best describe the difference between the two […]