• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

what are some most common VBA and general programming interview questions?

V

VAisforlovers

Senior member
For an upcoming interview, the company says that knowledge of VBA and general programming are highly preferred. What are some basic VBA and general programming questions that someone might get?
 
Jaydip said:
How much is your experience?
Click to expand...

I've used it during one of my internships and sparingly throughout the past few years. On my resume, I just have them listed under my technical skills with no mention competency level

I feel that I can do anything asked but I have to rely on google searches for help.
 
1. Why do you still use VBA?

Lol!

I would probably ask for the difference between a function and a sub and what two keywords you need to require advance declaration of variables.
 
Just Google vb interview questions. Your going to get asked about syntax, class differences, types, maybe how it's different or the same as other languages. Compile, maybe run time questions..maybe they will make you do fizz buzz lol.
 
VAisforlovers said:
I've used it during one of my internships and sparingly throughout the past few years. On my resume, I just have them listed under my technical skills with no mention competency level

I feel that I can do anything asked but I have to rely on google searches for help.
Click to expand...

Then it will vary from basic to intermediate.There are some good online tutorials available for VBA.I would personally ask why do you need VBA? 🙂
 
The majority of what I do currently is VBA (it is such a waste of time that there aren't many good developers for it). I mainly was asked what projects I worked on previously and what a Class Module was. Was easy for sure.

The difference between a function and a sub is such a stupid question. In fact it is a stupid "feature" of the language. I basically only use a Sub when I don't need a returned value (think void function in other languages). But, you can also have a function that doesn't return anything.

I might have also been asked about collections... can't recall.

It might be best just to state what you're fuzzy about and maybe we can help.
 
Tweak155 said:
The majority of what I do currently is VBA (it is such a waste of time that there aren't many good developers for it). I mainly was asked what projects I worked on previously and what a Class Module was. Was easy for sure.

The difference between a function and a sub is such a stupid question. In fact it is a stupid "feature" of the language. I basically only use a Sub when I don't need a returned value (think void function in other languages). But, you can also have a function that doesn't return anything.

I might have also been asked about collections... can't recall.

It might be best just to state what you're fuzzy about and maybe we can help.
Click to expand...

You forgot another thing Buddy, function name=return value.This is pure gem 😀
 
Jaydip said:
You forgot another thing Buddy, function name=return value.This is pure gem 😀
Click to expand...

Yeah that is pretty bad since if you don't specify it anywhere, the function returns a default value as if the type was dim'ed and no value specified.

So if you have a Boolean function and you never set functionname = true/false, it will always return false.

If it forced better requirements, it is as good as saying "return false;" for example, just another way of writing it.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top