Excel, vba interview question

Posted on 2011-05-06
Last Modified: 2012-05-11
Can any please please provide me with good links for excel vba interview questions?
Most important thing is to look at the codes - codes based questions
Also it would be great if some one want to add something.

Kind Regards,
Question by:SameerMirza

    Author Comment

    I guess I should have googled it first. Found a very good resource,
    LVL 9

    Accepted Solution

    Generally you will have 2 patterns offered by your interviewer.

    1. The first thing which will be tested is
    how much you are confident about VBA, if you are confident enough then how far you have already covered in this subject.

    Based on your claim you will be asked questions covering the area you are saying you are confident. Then interviewer might ask for to tell him something new (this is the best chance for scoring big if u could tell him something easily doable but a new perspective!)

    2. Practical:

    It is best to have idea about the followings:

    a, Declaring variables and constants.
    b. creating procedures
    c. defining scope for the procedures
    d. creating functions
    e. using vlookup, sumproduct like formulas in your vba code
    f. preparing reports using vba
    g. saving time for the organisation through your code.

    Best of luck :)


    Author Comment

    Thanks :)
    How owuld we define VBA.
    Its visual basic for application
    event driven language
    But It would be great if you could provide me with a definition

    LVL 9

    Assisted Solution

    VBA is for Visual Basic for Applications. A modified version of original Visual Basic. Why it is so? Because the vendor Microsoft has a category of product called Applications, under Applications they have MS OFFICE, in MS Office they have excel, access, powerpoint, outlook etc.

    Microsoft developed VBA to connect its applications programically, so we can perform opening word application from excel or access or outlook. Even we can perform word tasks like checking grammar using excel. So all these robust activities can perform using only one language that is VBA.

    Therefore it is  Visual basic for Applications.

    Author Comment

    ok thanks a lot.
    I should already alocate the points but I have very quick code question.
    What does the below line of code actually do?
    I understand that its looking for first empty line

    iRow = ws.Cells(Rows.Count, 1) _
    . end(xlUp).Offset(1,0).Row

    where ws = worksheet object
    I cant understand why '_' is there
    It would be very helpful if you can explain it a little.

    Kind regards
    LVL 9

    Assisted Solution

    The underscore "_" is for continuation to the next line.

    Generally we use this to continue writing our code to next line for better view.

    It is a programming technique but no action may delete underscore and write the line as

    iRow = ws.Cells(Rows.Count, 1). end(xlUp).Offset(1,0).Row

    Author Closing Comment

    All very helpful

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now