background preloader

Excel Stuff

Facebook Twitter

VBA. Nick Hodge's Excel Website. Welcome to my Excel pages.

Nick Hodge's Excel Website

These have been put together as a summary of my experiences with Microsoft Excel since version 5 in 1994. All data on here has been assembled using Excel 2003, FrontPage 2003, Windows XP SP2, Internet Explorer 6, but most should work in any browser/operating system and Excel versions from 97. Some of the code may also work in Excel versions before this, but the example files will not open in versions before 97. features available in Excel 2007 and hope to add some special stuff for this new version and a guide to where to find the old familiar features from your previous versions, shortly! Watch this space... I have been fortunate to be awarded MVP status, by Microsoft for 9 years and make my living entirely out of the IT industry, working as Managing Director of the UK arm of US Company Northern Tool + Equipment Co, MN.

I hope you enjoy your visit and find what you're looking for. Thank you Nick Hodge Copyright Nick Hodge 2009. Excel. Excel Dashboards: Who Needs Them, Anyway? You are not happy at work.

Excel Dashboards: Who Needs Them, Anyway?

I can clearly see that. Morale is low due to the economy, but it’s something else, isn’t it? You feel handcuffed. You keep hitting a wall. It hurts, hitting a wall while handcuffed… You work with data. More Pain Another quarter, another quarter review. Recently, a competitor launch an under-the-radar campaign in some counties. Guts ‘n’ Pies Management You know that something is wrong, you just know. So You Start Wondering You are not an Excel expert, it’s not your job, but you’ve been trying to automate as many boring tasks as possible.

And then a while ago you discover that two charts side by side are much better than one in each slide. VBA Tips Build an Excel Add-In. About Add-Ins An Excel Add-In is a file (usually with an .xla or .xll extension) that Excel can load when it starts up.

VBA Tips Build an Excel Add-In

The file contains code (VBA in the case of an .xla Add-In) that adds additional functionality to Excel, usually in the form of new functions. Add-Ins provide an excellent way of increasing the power of Excel and they are the ideal vehicle for distributing your custom functions. Excel is shipped with a variety of Add-Ins ready for you to load and start using, and many third-party Add-Ins are available. This article shows you how to write a custom function using Excel VBA and how to save and install it as an Add-In. In the Excel tutorial Working Out a Person's Age - An Introduction to Nested IF Statements I showed how to use IF statements to calculate someone's age from their date of birth. If you are already comfortable with writing custom functions, you can go straight to the section explaining how to save your UDFs as an Add-In.

Write the Function Step 2: Enter the Code. AJP VBA Coding. VBA Code VBA coding techniques, solutions and examples RibbonX Designer for 2010 VBA add-in with which to create ribbonx code for both 2007 and 2010.

AJP VBA Coding

Requires Excel 2010 to access customUI14 section. Chart Labeler for PowerPoint. A List of the Keyboard Shortcuts That Are Available in Windows X. This article describes the keyboard shortcuts that you can use to complete tasks in Windows XP.

A List of the Keyboard Shortcuts That Are Available in Windows X

General keyboard shortcuts Click here to show/hide list Dialog box keyboard shortcuts Click here to show/hide list If you press Shift+F8 in extended selection list boxes, you enable extended selection mode. Ctrl+Tab (Move forward through the tabs)Ctrl+Shift+Tab (Move backward through the tabs)Tab (Move forward through the options)Shift+Tab (Move backward through the options)Alt+Underlined letter (Perform the corresponding command, or select the corresponding option)Enter (Perform the command for the active option or button)Spacebar (Select or clear the check box if the active option is a check box)Arrow keys (Select a button if the active option is a group of option buttons)F1 key (Display Help)F4 key (Display the items in the active list)Backspace (Open a folder one level up if a folder is selected in the Save As or Open dialog box) Microsoft natural keyboard shortcuts.

Excel. Microsoft's VBA and VB Basic Programming. Excel VBA. Spreadsheets.