PDA

View Full Version : VBA FOR BEGINNER QCM



jennyjennyje
11-05-2009, 04:24 AM
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

jennyjennyje
11-05-2009, 04:39 AM
Pleasse anyone?
I need to submit the test in few minutes

lucas
11-06-2009, 10:25 AM
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?

lucas
11-06-2009, 10:30 AM
To test the second question put this in a standard module and run it.

You get a messagebox.


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



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

fumei
11-10-2009, 12:23 PM
Yikes.

Oorang
12-05-2009, 12:50 AM
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.