Interview Questions → VBA → VBA Questionnaire I

VBA Questionnaire I

What is a Macro?

We can relate Macro with many meanings, but when it comes to Microsoft office it is a process to automate the repetitive task.Macro is kind of statement which needs VBA platform for execution.

What is difference between vba and macros?

VBA is a platform where macro applications run.

What is difference between Formula and Function in excel?

Formula uses operator like /,*,-,+ whereas functions uses logical constructs like if,sumif,etc

What is difference between Find and Search functions in excel?

Both function returns location of the string but find function used to extract only those records that fulfill a specified criteria. For example if you find for S(capital s) in data set but there in data set small s exists than find function will return null

But search function will return the location form the data set even if the case doesn't match.

Posted By -

Vishal Parihar

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**