What is the value of x after the following code segment executes? Dim x As Integ
ID: 3727167 • Letter: W
Question
What is the value of x after the following code segment executes?
Dim x As Integer
For x = 1 to 10 Step 2
MsgBox "The value of x is " & x
Next x
What is the value of Z after the following VBA code executes?
Dim x As Integer
Dim y As Integer
x = 10
y = 11
z = 0
Do
z = z + x + y
Loop While z <= 0
What results when the following VBA code segment executes? Assume x = 7 and y = 7 and Z = 0.
Do While x = y
Z = x -y
Loop
What is the value of Z after executing the following VBA code segment if x = 5 and y = 10 and Z = 0 before execution.
Do While x > y
Z = x +y
Loop
Explanation / Answer
1. What is the value of x after the following code segment executes?
Dim x As Integer
For x = 1 to 10 Step 2
MsgBox "The value of x is " & x
Next x
Ans: Message Box Appears with text containing below for 10 times
The Value of x is 1
The Value of x is 2
The Value of x is 3
The Value of x is 4
The Value of x is 5
The Value of x is 6
The Value of x is 7
The Value of x is 8
The Value of x is 9
The Value of x is 10
2. What is the value of Z after the following VBA code executes?
Dim x As Integer
Dim y As Integer
x = 10
y = 11
z = 0
Do
z = z + x + y
Loop While z <= 0
Ans: Stack OverFlows, because you are doing loop as long as z values becomes less than or equal to zero and you're not decreasing z value inside the loop.
3. What results when the following VBA code segment executes? Assume x = 7 and y = 7 and Z = 0.
Do While x = y
Z = x -y
Loop
Ans: Again StackOverFlows, its clear that both x and y have same value, and you're looping as long as x and y are both equal. but you're not doing manipulations to x or you
4. What is the value of Z after executing the following VBA code segment if x = 5 and y = 10 and Z = 0 before execution.
Do While x > y
Z = x +y
Loop
Ans: it doesn't enter loop and z values doesn't changes and always '0' (which is initial value). because you're entering loop only x greater than y but its clear that x is 5 and y is 10.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.