?
Solved

Excel, vba interview question

Posted on 2011-05-06
7
Medium Priority
?
817 Views
Last Modified: 2012-05-11
Hi,
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,
 
0
Comment
Question by:SameerMirza
  • 4
  • 3
7 Comments
 

Author Comment

by:SameerMirza
ID: 35711105
I guess I should have googled it first. Found a very good resource,
http://www.excelitems.com/2010/12/excel-vba-interview-questions.html
0
 
LVL 9

Accepted Solution

by:
suvmitra earned 2000 total points
ID: 35711163
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 :)





0
 

Author Comment

by:SameerMirza
ID: 35711197
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

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Assisted Solution

by:suvmitra
suvmitra earned 2000 total points
ID: 35711215
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.
0
 

Author Comment

by:SameerMirza
ID: 35711225
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
0
 
LVL 9

Assisted Solution

by:suvmitra
suvmitra earned 2000 total points
ID: 35711241
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 value..you may delete underscore and write the line as

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

Author Closing Comment

by:SameerMirza
ID: 35711262
All very helpful
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

850 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