+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

VBA Interview Questions and Answers

1
Explain what is VBA or Visual Basic for Applications?

VBA stands for Visual Basic for Applications; it is an event driven programming language developed by Microsoft. It is predominantly used with Microsoft office applications like MS-word, MS-Access, and MS-Excel.

2
Explain the difference between Msgbox Statement and MsgboxQ function?

MsgBox is a built in VB function which displays a Message Box and MsgBoxQ is a function defined by the user.

3
Mention where you can write your VBA program for Macro?

Module is the place where you can write VBA program for Macro, to insert a Module navigate to Insert -> Module

4
Explain Which controls can not be placed in MDI?

The Controls which do not have Align property can't be placed on MDI Form.

E.g., Picturebox only has Align property in Standard Components of VB other controls dont have align property an hence can't be drawn on MDI Form.

Timer control can also be placed on MDI form.

5
Mention what are the comments style used in VBA?

Comments are used to document the program logic and the user information with which other programmers can work seamlessly on the same code in future. There are mainly two methods in VBA to represent comments.

  • Any statement that begins with a single quote is treated as comment
  • Or you can use statement REM instead of single quotation mark (‘)
Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US