This is one of those posts that is really only for my own benefit. I recently decided to tackle the idea of rather than just putting red, yellow, and green indicator lights on a spreadsheet to indicate how close we were to meeting budget in certain areas, I would programatically allow Excel to determine [...]
Posts Tagged ‘VBA’
Progressive Status Indicators in Excel
Posted in Excel, tagged Color, VBA on 2008.07.10 | 4 Comments »
Getting Information From the Web Using Excel VBA
Posted in Excel, tagged HTML, Internet, VBA on 2008.06.30 | 4 Comments »
What we’re trying to do today is get a value from a webpage and return it to a custom function within Excel. I’m going to use a very simple example, and it should be inferred that this is only for very simple tasks. The information you seek to return to your function will need to [...]
Create Your Own Excel Add-Ins
Posted in Excel, tagged Add-In, Excel, VBA on 2008.06.20 | 2 Comments »
Yesterday I showed you how to create your own functions using Excel VBA, or Visual Basic for Applications. Today’s post will take this to the next level.
If you’ve played with creating and using your own functions, you may have noticed that once you close that workbook, you lose the ability to use that function. [...]
Create Your Own Excel Formulas
Posted in Excel, tagged Excel, Formulas, VBA on 2008.06.19 | 6 Comments »
How to use Excel VBA to hand-craft custom functions for spreadsheets requiring complex functions.
