Author: FinancialRadDeveloper

I am an Excel VBA RAD Developer in Banking. I am trying to share the tips and info I have picked up in the last few years.
Excel by FinancialRadDeveloper

Triskaidekaphobia! Or in English: Microsoft Excel Team’s fear of 13.


So today when I saw something that look like this it made me smile:

Public Enum ExcelVersionEnum
    Excel4 = 4
    Excel95 = 7
    Excel97 = 8
    Excel2000 = 9
    Excelxp = 10
    Excel2003 = 11
    Excel2007 = 12
    Excel2010 = 14    'Triskaidekaphobia!
End Enum

There is no Excel version 13.  I of course only just found this out when I encountered Excel 2010 which, I blush to admit, I have not downloaded from TechNet yet and played with.

Triskaidekaphobia (from Greek tris meaning “3,” kai meaning “and,” and deka meaning “10”) is fear of the number 13; it is a superstition and related to a specific fear of Friday the 13th, called paraskevidekatriaphobia or friggatriskaidekaphobia.

Source : en.wikipedia.org/wiki/Triskaidekaphobia

Continue reading Triskaidekaphobia! Or in English: Microsoft Excel Team’s fear of 13.
VBA by FinancialRadDeveloper

Do you use protection? Really useful factoid – 002


We are all told that using protection is a good thing.  This applies to both real life and also programming, both in full OOP and the quasi OOP world of VBA / VB. It can be possible in some cases for your variables to be changed inside the sub / function you have called, even the ones one may have designated in your human mind as ‘input’ variables.   This can lead to odd behaviour and hard to find bugs.

So.. what am I going  on about?  Well I am talking about passing by value or by reference.  (Experienced VBA Programmers may want to skip this bit).   In VBA you can use two keywords ByRef or ByVal when defining your Sub or Function.  

Continue reading Do you use protection? Really useful factoid – 002