Excel and VBA Tips

Throttle RTD Interval
By default, Microsoft Excel will throttle RTD updates into your spreadsheet. This means that data can be delayed, especially if
About RTD
DDE Dynamic Data Exchange (DDE) is a Microsoft technology for transferring information between applications and is the older of the
Install 64 bit Excel
By default, Microsoft recommends and installs the 32 bit version of Office (and Excel). The main reason, I believe, is
The easiest way to tell which bitness your Excel is running, is to open Task Manager on Windows using Ctrl+Shift+Esc
Excel 2003 Excel 2007 Excel 2010 Excel 2013 Excel 2016 Excel 2019 Excel 365 Excel 2003: Excel 2003 had a
Excel Developer Toolbar
Let's face it, buttons are cool. As a VBA Trader, at some point you need to add a button to