Are you preparing for VBA For Excel job interview? Need Some interview question and answers to clear the interview and get your desired job in first attempt? Then we the Wisdomjobs have provided you with the Interview Questions . If you are well familiar with the VBA For Excel topics then there are various leading companies that offer various job roles like VBA/MIS Executive, VBA Macro/excel Developer, MIS Analyst - MS Excel & VBA, VBA Developer, Analyst/Senior Analyst - Excel/VBA/SQL and many other roles too. To know more on VBA For Excel job interview question and answers and various VBA For Excel job roles please feel free to visit our site Wisdomjobs page. Here's how to prepare for the interviews to win in first attempt.
Question 1. Explain About Visual Basic And Its Importance?
Answer :
Microsoft holds license for Visual basic applications and it has been developing that language. Visual basic applications have an embedded programming environment which assists programmers in developing custom solutions by using almost all features of visual basic. Applications which are currently hosting visual basic can fully utilize the power of Visual basic applications because they have an added functionality and ease of visual basic applications.
Question 2. State The Difference Between Visual Basic, Vb Script And Visual Basic Applications?
Answer :
Question 3. Name The Platforms Through Which Visual Basic Applications Are Available?
Answer :
Most of the visual basic applications are available on 32 bit Intel platforms. These applications also run on many of the windows software systems such as server 2003, XP, Vista, etc.
Question 4. Define And Explain About Com Add-ins?
Answer :
COM add-ins are software program's which are integrated into an application and they add already built in features to an existing application. They have common architecture across multiple applications which help in deploying applications much faster across varied applications. Microsoft 2007 supports various COM add-INS.
Question 5. How Best Can A Programmer Utilize The Benefits Of Vba With Office (07)?
Answer :
Microsoft office 2007 supports Visual basic and has support with many various features. With MS office 2007 you can use desktop applications for creating tailored business solutions. These desktop applications can be used directly as construction sites.
Question 6. Explain About The Security Vulnerabilities For Vba?
Answer :
Microsoft Visual basic has its host of problems one such being macros, Macros can be created which can create a havoc for a programmer with good intentions. Also the security issue rests in the hands of the user and not the programmer as such. A user can manipulate the VBA document.
Question 7. Explain About Line Option Explicit?
Answer :
Line explicit function makes the compiler to identify all the variables which are not specified by the dim statement. This command significantly reduces the problem of type errors. This is used extensively because VBA deals with information rich applications in which type errors are common.
Question 8. Give Technical Reasons Which Made Microsoft Withdraw Its Support For Vba In Mac?
Answer :
The reasons which made Microsoft drop its support to VBA are as follows, Microsoft visual basic relies heavily on machine code which was written for Power PC architecture. Also it would take another two years for developing VBA support for its architecture. It also states that Microsoft will incorporate VBA in the next script of office release for Mac.
Question 9. How Can You Format Expressions By Using Vba?
Answer :
Format functions can be used to format many of the expressions such as currency, time, date, percentages and numbers. These functions are much simpler to use in VBA. User defined date, numeric and string formats are present in many of the applications.
Answer :
A computer registry can be used to store configuration settings and application initialization. We can use Getsetting function to read registry settings and save settings function to write registry settings. Application name, section, key, setting, and default are to be specified for registry modifying. It is advisable to know about your computer settings before modifying registry settings.
Question 11. What Forms Should Be Used For Complex User Input?
Answer :
Userforms should be used for complex user input. When an application input has non text as an input it is advisable to use Userforms rather than the input boxes. When you are using Userforms a user can give input any number of times which is not the case when you use input boxes. This can be accessible from the insert menu in your VBA editor after which you can insert your code.
Question 12. Explain About Function Pointers?
Answer :
Visual basic applications have very rich and flexible applications but there is one limitation when using pointer function. Windows API has limited support for function pointers because it has the ability to use but not the functional support to call back the function. But later versions have support for modules. Function pointers have inbuilt support (DLL's) for call but not for call back.
Question 13. State Some General Uses For Visual Basic Applications In General Context?
Answer :
Visual basic can be used within almost all Microsoft products such as Map point, Visio, Auto cad, Word perfect, ArcGIS, word, excel, etc. With VBA you can control many functions such as host application, menus, toolbars, user interface, import and export of files, data transfer and extraction from multiple interfaces.
Question 14. Explain About Insert Module And Goal Seek Functions Present In Vba?
Answer :
The chief use of VBA is to make use of its special function which helps in repeated actions. Goal seek function helps to reduce manual entry of the code each and every time. This solves the problem of repeated function entry by automating functions and actions. Sub routines are inserted into the using the VBA editor and command insert module.
Question 15. How Can We Use Data Validation Function In Vba?
Answer :
Data validation is an important concept in VBA. Application procedure and a custom dialog box can be used to correct input errors. You can assign an application procedure to the frame of a dialog box. Error message or custom dialog box can be highlighted with the first field with errors.
Question 16. How Can We Dial A Phone Number?
Answer :
Shell command present in VBA can be used to start the dialer present in windows operating system. Phone number can be used to connect to your modem. With the use of shell and sendkeys you can dial to your user. Shell starts windows application and sendkeys inform the window to dial according to the keystrokes of the application. A macro can be used to start the cardfile program which activates the auto dialer feature.
Question 17. What Is The Difference Between Byval And Byref And Which Is Default ?
Answer :
Question 18. What Is The Meaning Of Option Explicit And Option Base?
Answer :
Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0.
Question 19. What Are Various Data Type And Their Size?
Answer :
Question 20. Difference Between Activeworkbook And Thisworkbook.
Answer :
ThisWorkbook refers to the workbook where code is being written while ActiveWorkbook refers to the workbook which is in active state with active window. In case of only one workbook open, ActiveWorkbook is same as ThisWorkbook.
Question 21. Code To Find A Last Used Row In A Column Or Last Used Column Of A Row.
Answer :
Last Row in a column can be find using End(xlUp) and Last Column in a row can be find using End(xlToLeft). For e.g. Range("A1048576").End(xlUp).Row gives last used row of Column A.
Question 22. Difference Between Activex And Form Controls.
Answer :
Question 23. What Is The Difference B/w Functions And Subroutines?
Answer :
Question 24. How To Debug A Vba Code?
Answer :
Using Breakpoints(F9), Step-by-step execution (F8), Debug.Print & Immediate Window and Watch window.
Question 25. Draw Basic Excel Object Model?
Answer :
Application --> Workbooks --> Worksheets --> Range / Chart.
Question 26. Can You Lock Cells Such That Only Specific Users Can Modify Them?
Answer :
There is a option "Allow users to edit ranges" can be used for this purpose.
Answer :
Using 'Data Validation'.
Question 28. How Can You Increase The Number Of Rows In A Worksheet?
Answer :
No one can't. They're fixed as 65536(2^16) in Excel 2003 or before and 1048576(2^20) in Excel 2007 & Excel 2010.
Question 29. How Can You Increase The Number Of Columns In A Worksheet?
Answer :
No one can't. They're fixed as 256(2^8) in Excel 2003 or before and 16384(2^14) in Excel 2007 & Excel 2010.
Answer :
We can create a workbook which cannot be modified but cannot create a workbook which can't be copied.(It depends on system security, it has nothing to do with Excel or VBA)
Question 31. What Types Of Workbook Protection Are Available?
Answer :
Excel provides three ways to protect a workbook:
Answer :
Use Application.Dialogs(xlDialogFont).Show or Application.Dialogs(xlDialogFormatFont).Show to load font dialog box from Excel VBA.
Question 33. What Is Ado, Oledb & Odbc?
Answer :
ADO : ActiveX Data Objects is universal data access framework that encompasses the functionality of DAO.
ODBC : Open Database Connectivity(ODBC) is a windows technology that lets a database client application connect to a external database.
OLEDB : Low level programming interface designed to access a wide variety of data access Object Linking and Embedding (OLE).
Question 34. How To Set The Custom Paper Size In Excel Object Through Vb?
Answer :
Activesheet.PageSetup.PaperSize = xlPaperLetter (Similarly xlPaperA4 or xlPaperLegal etc.).
Question 35. What Is The Method For Returning More Than One Values From A Function In Vb?
Answer :
Any of the three methods can be used:
Question 36. Does Vba Supports Oop Principles?
Answer :
Yes because VBA is VB6.0 based which is an Object Based Programming Language and is also known as 'Event Driven Programming' and it supports Polymorphism, Encapsulation and partially Inheritance.
Question 37. To Set The Command Button For Esc, Which Property Needs To Be Changed?
Answer :
Set Cancel property of Button to True on the Form.
Question 38. What Is Type Library And Its Purpose?
Answer :
Type libraries are files that explicitly describe some or all of the contents of components. This includes information about the methods properties constants and other members exposed by the component. Development tools such as Visual Basic make use of the information contained in the type library to help you as a developer access and use the component. In addition type libraries provide a convenient way to include a simple level of descriptive documentation for component members. You can use them through 'Tools --> References' in VBE.
Question 39. What Is A Volatile Function?
Answer :
Volatile functions are a type of function that will always recalculate. That means whenever Excel needs to calculate any part of the worksheet, those cells containing volatile functions will also calculate.
Question 40. How Do You Make A Udf Volatile?
Answer :
By adding Application.Volatile statement to it. It must be the first line of your User Defined Function.
Answer :
Actually INDEX is not a volatile function, even though some MicroSoft documentation says it is. Anyway no its not possible to apply Application.Volatile(False) to a built-in Excel function except by duplicating what the built-in function does inside a UDF.
Question 42. What Is Excel Dependency Tree?
Answer :
Question 43. How Do You Check The Calculation State ?
Answer :
using the Application.CalculationState property which tells if calculation has completed ( xlDone ), is pending ( xlPending) , or is in process ( xlCalculating ).
Question 44. What Are Excel Dependency Tree Limits?
Answer :
There are two limits to the number of dependencies that Excel versions prior to Excel 2007 can track before it must do full calculations instead of recalculations.
After the workbook has passed these limits, Excel no longer attempts to recalculate only changed cells. Instead, it recalculates all cells at each calculation.
Question 45. What Do You Know About The Interpretation Features Of Vba?
Answer :
VBA is licensed to Microsoft and this compatible with and only Microsoft products. Code written is compiled by an intermediate language called P-code and this is stored in hosting applications such as Excel, Word and Access. The intermediate code is interpreted by a virtual machine. This code and intermediate language is the exclusive right of Microsoft.
Question 46. What Is The Difference Between Usedrange And Currentregion Properties ?
Answer :
Question 47. Which Are The 2 Macro Languages And Which Do You Use ?
Answer :
XLM (used in Excel 97 or before) and VBA(used for 2000 and after). Obviously, VBA is in use these days.
Question 48. What Is View Port?
Answer :
The area under which the container provides the view of the ActiveX Document is known as a view port.
Question 49. What Is The Size Of The Variant Data Type?
Answer :
The Variant data type has a numeric storage size of 16 bytes and can contain data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length),and can store any character text.
Question 50. What Are The Different Types Of Error?
Answer :
Syntax Errors, Runtime , Logic.
Question 51. Can We Create Cgi Scripts In Vb?
Answer :
Yes.
Question 52. What Are The Different Types Of Dialog Box?
Answer :
Predefined, Custom, User Defined.
Question 53. What Are The Scopes Of The Class?
Answer :
Public, private, Friend.
Question 54. What Is The Difference Between Property Get, Set And Let?
Answer :
Set Value is assigned to ActiveX Object from the form. Let Value is retried to ActiveX Object from the form. Get- Assigns the value of an expression to a variable or property.
Question 55. What Are The Type Of Validation Available In Vb?
Answer :
Field, Form.
Answer :
Messaging Application programming Interface.
Question 57. What Are The Style Properties Of List Box?
Answer :
Simple Single Select , Extended, Multiple Select.
Answer :
DCOMCONFIG.EXE.
Question 59. Which Controls Cannot Be Placed In Mdi?
Answer :
The Controls which do not have Align property can't be placed on MDI Form.
Question 60. What Is The Dll Required For Running The Vb?
Answer :
Vbrun300.dll.
Answer :
The Parameters collection.
Question 62. What Are Some Benefits Of Using Mts?
Answer :
Database Pooling, Transactional operations, Deployment, Security, Remote Execution.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.