I don't think I'd go overboard on VBA - they need to know Excel pretty
well, and they need to be able to program - so standard logic
questions, and questions like what formulas you would use to do some of
the work you ACTUALLY need to have done would point you in the right
direction!

You might like to use this link though

http://uk.ask.com/web?q=excel+vba+jo...=0&o=& dm=all

Neil Kiser wrote:
Hi,
There is another group in my organization that is inteviewing consultants
for a VBA position and I was asked to technically interview these candidates
because of my VB experience. However, I have no VBA experience whatsoever.

Was curious if anyone out these might offer up a handful of questions (with
answers please LOL) that I might ask these candidates. I have to start
interviewing at 10:30 am central time today (nothign like waiting until the
last minute) - so if you read this after then no need to respond.

Thank you very much, and if you have just one question - please offer it if
you don't mind, I'll just pool questions that I receive. :) (oh, and this
is VBA with Excel)

Thank you!
-Neil