VBA FOR BEGINNER QCM

Hi guys,

I just started with vba in excel,
does anyone know the answers of thise two questions?

Question 1

Marks: 1 Consider the following expression:

switch(MyTest, MyVal1, True, MyVal2)

Which of the following remarks about it is True?

Choose one answer. a. it is exactly equivalent to iif(MyTest = MyVal2, MyVal1, True)
b. it is exactly equivalent to iif(MyTest = MyVal1, MyVal2, True)
c. it is exactly equivalent to iif(MyTest, MyVal1, MyVal2)
d. it is exactly equivalent to iif(MyTest, MyVal2, MyVal1)
e. it is exactly equivalent to iif(MyTest = MyVal1, True, MyVal2)

Question 2
Marks: 1 A variable MyVar is defined within a procedure called MyProc in a module called "Module 1".

Dim MyVar as Integer

Which of the following is most correct?

Choose one answer. a. MyVar can be used within loops and branches within MyProc but nowhere else
b. MyVar can be used anywhere within Module 1, but not outside the module
c. MyVar can be used within the procedure MyProc but no where else
d. MyVar can be used within the spreadsheet, but no where else

Pleasse anyone?
I need to submit the test in few minutes

Jenny, we would be glad to discuss these things with you but since it's classwork, we can't just give you the answers.

You should come here before it's just a few minutes till you take the test.

Question 2 is so very basic that I'm surprised that you don't know the answer. If it's defined within a procedure then what does that tell you?

To test the second question put this in a standard module and run it.

You get a messagebox.

[VBA]
Sub test()
Dim MyVar As String
MyVar = "My Message"
MsgBox MyVar
End Sub

[/VBA]

Now make another sub but don't define MyVar. Just put the
[VBA]MsgBox MyVar [/VBA]
in the sub and run it. What happens?

Yikes.

What I want to know is what class is teach you to use switch and iif instead of select case and if?

Btw at this point the answers I feel OK with telling you that answers are C & C.