Introduction Everywhere I have ever worked (I am mainly talking about the standard sell side Wholesale / Investment banks) use Excel & VBA for their prototypes and any desk based development. While lots of time, […]

Introduction Everywhere I have ever worked (I am mainly talking about the standard sell side Wholesale / Investment banks) use Excel & VBA for their prototypes and any desk based development. While lots of time, […]
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.
I have heard of this question coming up a little bit in all sorts of technical interviews so I thought I would set it as a G Challenge. Question: “Please tell me what you would […]
I guess a major point of RAD is speed. The clue is right there in the name: Rapid Application Development. So, all other things being equal, how do we go about getting more speed. I […]
Ok, my friend is trying to learn Excel VBA and get into RAD development. I am going to set a number of challenges which I am going to call a ‘G Challenge’ 😛 So the […]
I thought that I would compile a list of things that *I* think every good Excel developer should know. I don’t mean techniques in particular, just things that people who work with Excel VBA intensely each day should know.
Edit: I think a lot of people will be searching for Excel VBA Interview questions and answers so I have renamed the post and changed the format slightly. I will include all the answers on a separate post so people can try these for themselves and use it to check, or just go there immediately and cheat ;-P
I’ll illustrate : Alt+F11. If you don’t use this, or don’t know when asked what it does, I would say you know Jack about VBA. This is only my own opinion, but a lot of these things do come up as interview questions as they are quite esoteric and won’t really be something a pretender would, or come to think about it, could Google for when cramming for the interview.
I’ll start simple and group things up so they should all make sense.
I started this blog mainly to record my experiences while looking for Excel / VBA roles. I do remember that there were a number of blogs that I myself found very useful. This one always […]
I have a friend who is just starting out in the professional Excel world. I thought it would be a good opportunity to write about my advice on starting out with VBA Macros from the very beginning and post it here.
My first advice would be to have a good play with the Macro recorder.