Archive

Archive for the ‘Advanced’ Category

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.   Read more…

Advertisements

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?

Read more…

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… Read more…

Categories: Advanced, Factoid, Off Topic, Random, WTF

Excel VBA Interview questions


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 stick in my mind as I remember using 2 posts on the blog for both my current spate of job hunting and also the previous spate where I first started to look for Excel / VBA / RAD roles when I worked out I just wasn’t going to make a very good C++ programmer.

Excel VBA Questions:

http://www.toomik.net/helen/blog/2007/01/31/interviewing-for-an-excel-vba-job/

Hiring:

http://www.toomik.net/helen/blog/2006/02/28/hiring/

I’ll post some more thoughts up on a re-edit, I just thought  I would post this up right now in my lunch break first.