It looks like I get to be the first guest speaker to blog here, so thanks to Dick for opening up his Daily Dose.
When we write code, we can generally trust that it will work just as well on our users’ computers as on our own. Given the same source data, bugs are generally reproducible. Unfortunately, that is not the case if our users are overseas.
With a little care and foresight, it is possible (and quite easy) to write VBA code that will work wherever it’s used, with any choice of Windows or Excel UI language and any combination of Regional Settings (such as the date order and the characters used for the thousands, decimal and list separators).
I wrote a chapter about this in John Green’s “Excel 2002 VBA Programmer’s Reference” and Wrox Press have recently agreed for me to include it on my web site. I urge you to read the chapter and incorporate its recommendations into your standard coding habits.
You can read the chapter at http://www.oaltd.co.uk/ExcelProgRef/Ch22.