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, […]
Category: Office 2007
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 […]
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 […]
Adding accented characters into your Excel workbook is commonly achieved by using the Insert –> Symbol menu options to select the character you want, however while this is fine for inserting the odd symbol every now and again, if you have to enter lots of different symbols then things can become very tedious indeed. Fortunately Microsoft have provided a […]
Microsoft Excel provides a very handy function called the ‘Info’ function which allows Workbook designers to give users various system information without a lot delving around in VBA etc. For this demonstration we will use the Info function to enter the directory path of the current workbook into a cell. Firstly you will need to […]