+ Reply to Thread
Results 1 to 5 of 5

VBA Interview Questions

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    VBA Interview Questions

    Guys,

    I have an open position and want to hire a peer, but I need some help with some questions for the interview ==>VBA, DBs, etc.

    Can you please provide some valid VBA questions you use to hire a DEV?

    Thank you!
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: VBA Interview Questions

    I've hired developers for their VBA and DB ability before but rather than ask them specific questions about it I like to ask them to explain projects they've developed in the past. The usual why and how questions apply.
    That often gives a good idea of ability level and will quickly weed out those who SAY they can write VBA and build databases leaving only those that actually have a clue where to start.

    Then I give them practical tests. Show them a chunk of VBA (with the context of the file) and ask for them to translate it into words.

    Only once have I hired someone that got through that test and couldn't hit the ground runnning when it came to starting their new job.

    BBS

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA Interview Questions

    I'm all about practical application tests too, you'd be amazed how many "programmers" fail FizzBuzz.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: VBA Interview Questions

    Moved to the Water Cooler forum

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: VBA Interview Questions

    I've never hired for VBA Dev. But general coding / logical thinking question.

    1. Have iterative / recursive code. Ask interviewee to convert it to the other type.

    2. Write code to list Pythagorean triples (a^2 + b^2 = c^2) when minimum value for a and maximum value for c is supplied.

    Then, I usually like to see what sort of project they've worked on, and what they'd do differently given their current knowledge (if any).

    Below link may test both db and Excel skill.
    http://dailydoseofexcel.com/archives...nd-sql-skills/
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel questions to ask in an interview
    By CBJason in forum Excel General
    Replies: 12
    Last Post: 02-20-2015, 04:16 PM
  2. Provide me Interview Questions on VBA
    By d.balaji.naik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2013, 05:40 AM
  3. Provide me Interview Questions on VBA
    By d.balaji.naik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 05:33 AM
  4. Consolidation of interview questions for different departments
    By reginafilangie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2012, 04:28 PM
  5. Questions to ask a candidate for an interview
    By JieJenn in forum The Water Cooler
    Replies: 18
    Last Post: 03-30-2012, 11:50 AM
  6. Job Interview - Trading Desk - Technical Questions
    By PingPing in forum Excel General
    Replies: 0
    Last Post: 03-27-2012, 05:44 AM
  7. VBA Interview Questions
    By Neil Kiser in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-23-2006, 05:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1