VBA Developer
10+ VBA Developer Interview Questions and Answers
Asked in WNS
Q. Q) Difference between procurer and function ? A) procurer := Does not retunes value to user Function := Retunes the value to the user Q) Option explicit ? A) To declarer the variable at module level mandatory Q...
read moreExplaining the difference between procurer and function, and the purpose of Option Explicit in VBA development.
Procurer does not return a value to the user, while Function does.
Option Explicit is used to declare variables at the module level, making it mandatory.
Project explanation refers to the description of what was done in a particular project.
Asked in EXL Service
Q. There are three switches and one bulb in another room. You need to determine which switch turns on the bulb, but you can only enter the room with the bulb once. How do you solve this?
Turn on one switch, wait for a while, then turn it off and turn on another switch. The switch left on is the one connected to the bulb.
Turn on switch 1 and leave it on for a few minutes
Turn off switch 1 and turn on switch 2
Go to the room with the bulb, the switch left on is the one connected to the bulb
Asked in CinchiT Solutions
Q. Write a program to demonstrate your understanding of programming structures.
Understanding programming structures is crucial for effective coding and problem-solving in VBA development.
1. Control Structures: Use If...Then...Else for conditional execution. Example: If x > 10 Then MsgBox 'Greater than 10'.
2. Loops: Implement For...Next or Do...Loop for repetitive tasks. Example: For i = 1 To 10: MsgBox i: Next i.
3. Functions: Create reusable code blocks with Function/Sub procedures. Example: Function Add(a As Integer, b As Integer) As Integer.
4. Error H...read more
Asked in CinchiT Solutions
Q. How do the different types of Loops work?
Loops are used to execute a set of statements repeatedly until a condition is met.
For loop: executes a set of statements for a specified number of times
While loop: executes a set of statements as long as the condition is true
Do-While loop: executes a set of statements at least once, and then repeatedly executes the set of statements as long as the condition is true
For Each loop: used to loop through each element in an array or collection
Asked in Slp Technologies
Q. Why is string reversal only possible in macros?
String reverse is possible in VBA macros because VBA provides built-in functions and methods to manipulate strings.
VBA macros have access to the VBA string manipulation functions like Mid, Left, Right, and Len.
VBA macros can use loops and conditional statements to reverse a string character by character.
VBA macros can also utilize the Split function to split a string into an array of characters and then reverse the array.
VBA macros can easily convert a string into an array of...read more
Asked in CinchiT Solutions
Q. Different types of Excel formulas, Conditions
Excel formulas can be categorized into mathematical, logical, text, date/time, and lookup/reference formulas.
Mathematical formulas perform arithmetic operations like addition, subtraction, multiplication, and division.
Logical formulas evaluate conditions and return TRUE or FALSE.
Text formulas manipulate text strings.
Date/time formulas perform calculations with dates and times.
Lookup/reference formulas retrieve data from a specific cell or range.
Examples: SUM, IF, CONCATENATE,...read more
VBA Developer Jobs
Asked in Ascendion
Q. 1) Libraries required for predictive model building?
Libraries such as scikit-learn, TensorFlow, and Keras are commonly used for predictive model building.
scikit-learn
TensorFlow
Keras
Asked in Publicis Sapient
Q. Write a VBA code to convert 2/2/2022 into text.
Use VBA code to convert 2/2/2022 into text format.
Use the Format function in VBA to convert the date into text.
Specify the desired format within the Format function.
Example: Format(#2/2/2022#, "mmmm d, yyyy") will convert 2/2/2022 to February 2, 2022.
Share interview questions and help millions of jobseekers 🌟
Asked in Publicis Sapient
Q. What is a custom function in VBA?
A custom function in VBA is a user-defined function that performs a specific task or calculation.
Custom functions are created by the user to extend the functionality of Excel or other Office applications.
They can be used to perform complex calculations, manipulate data, or automate tasks.
Custom functions are written in VBA code and can be called from within Excel formulas.
For example, a custom function could be created to calculate the average of a range of cells or to format...read more
Asked in Congruent Solutions
Q. Explain about Userform and modules
Userform is a graphical interface for users to interact with data, while modules are containers for VBA code.
Userform allows for creating custom forms with input fields, buttons, etc.
Modules are used to store VBA code that can be called from other parts of the program.
Userform can be used to collect user input and display information in a visually appealing way.
Modules can contain functions, subroutines, and variables that can be accessed throughout the VBA project.
Asked in Publicis Sapient
Q. How do you use the SUM and COUNT formulas in VBA?
The SUM formula adds up a range of numbers, while the COUNT formula counts the number of cells that contain numbers.
Use SUM formula to add up a range of numbers, like =SUM(A1:A10)
Use COUNT formula to count the number of cells that contain numbers, like =COUNT(A1:A10)
You can also combine these formulas, like =SUM(A1:A10) + COUNT(B1:B10)
Interview Questions of Similar Designations
Interview Experiences of Popular Companies
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Reviews
Interviews
Salaries
Users
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
