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.

Essential material for Excel VBA RAD Development


I have been doing Excel VBA RAD ( Rapid Application Development) for over 4 years now, and I thought it would be useful to list all of the most useful resources that I have found over the years in one post.   I guess as much for my own benefit as for other readers.

Print :

Excel Development:

Professional Excel Development:

This has to be “The Bible” of all professional Excel developers.  I am being quite bold in this claim. 

Excel VBA Interview Questions (aka Things every *good* Excel VBA developer should know)


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.

Excel Interview Questions

Easy

  • What does Shift+D do in this case?
  • What does Ctrl+D do in this case?

  • What will happen if I pull down on the corner using the plus symbol making the 1×3 cell deep selection grow to 1×10?

Really useful factoid – 001


Where I am developing at the moment an unusual little character is being used.  It’s this one  ‘¬’.  Its what you get with Shift+`  which for most (PC, non laptop I mean) keyboards is Shift+top left key on the keyboard.   When I first saw it I only had to have a 2 sec scan of my keyboard to work out how to type it myself.  I guess years and years in front of something quite limited will lead it to soaking in!

What I did find interesting is that Google and the other search engines tend to remove characters from their search terms or presume that you want to do an advanced search if you do use them, so I was out of luck to work out what the little blighter is called.  I know a ‘~’ is a tilde.  I don’t know where I knew that from either, so apart from looking like a bit of a loon and asking my whole team if they knew I resolved to work out how I could get to know, and then also all the weird other things that can be generated.

A few minutes went by and then it hit me…

Found my first Googlewhack!


Awesome!   Its a bit sad, but after watching the DVD of Dave Gorman’s Googlewhack adventure I did struggle to find out how he found so many and the stories and people he met really struck a cord with me.

Dave Gorman's Googlewhack adventure
Dave Gorman's Googlewhack adventure

My Googlewhack?   ‘Argentine omniglossolalia’   it was used in an Independent article I was reading this morning as something made me take the free Independent paper that they are giving out until the conclusion of the UK Election.

I have yet to find out what omniglossolalia actually means which is how I stumbled across the Googlewhack itself.  

Is contracting for me?


So I guess even before thinking of accepting that contract its worth looking into if it is worth going contract on a particular rate?

Examples are good, I like clear examples so I shall endeavour to give the reader one.  There is enough HR waffle involved in this sort of thing normally!   So take a £50k Perm IT position.  To equal that on a daily rate would be in my estimation approx £220 p/day.  I get to this number by looking at working 230 days per year.  This magic number is taken from 260 possible working days.. 365 * ( 5 /7 ).    Then you need to take account of the 8 or so public holidays you probably won’t be able to work.  Then in order to have a life