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 […]
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.
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.
Excel Interview Questions
- 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?
I have to say that poor old VBA and Excel gets blamed for a lot of things. I guess its just easier for people who should never be allowed near a computer let alone develop […]
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.