Determining suitable parameters if pass-by-reference is used

Assignment Help Programming Languages

Reference no: EM1345950

Q1) Functions and subprocedures in VBA utilize pass-by-reference (by default), which can result in unexpected behavior if the parameters of the function are modified. Which function or sub procedure alters its parameter?

Answer

a. Function a(lngA As Long) As Long
a = lngA * 2
End Function

b. Function b(lngA As Long) As Long
lngA = lngA * 2
End Function

c. Sub c(lngA As Long)
Dim lngB As Long
lngB = lngA * 2
End Sub

d. Function d(lngA As Long) As Long
d = d * 2
End Function

Reference no: EM1345950

Questions Cloud

What is the effective resistance of television set : If the football has a mass of 0.47kg and the time of contact with the ball is 0.021s, what is the force exerted by the ball on the kicker's foot.

Determine the amortization period for rest of the costs : How much of start-up cost & organization expense can be deducted in the 1st year of operation? What is the amortization period for the rest of the costs?

Discuss whether you agree or disagree with chairman bernanke : discuss whether you agree or disagree with Chairman Bernanke's remarks on economic outlook and the role of the Fed' s monetary policy effectiveness by using unconventional policy.

What is the least wavelength the sound wave : A sailor strikes the side of his ship just below the surface of the sea. He hears echo of the wave reflected from the ocean floor directly below 9 s later. How deep is the ocean at this point.

Determining suitable parameters if pass-by-reference is used : Subprocedures in VBA utilize pass-by-reference. Which function or sub procedure alters its parameter?

Illustrate what is the profit made by each firm : explain how many smoothest sold by each firm, and illustrate what is the profit made by each firm.

Find the normal to the top surface of the glass : A tank with vertical walls, 2m wide and 2m long and 2.5 m high, is filled with 4800 litres of water (density 1000 kg/m3) and 3200 litres of light oil (density 900 kg/m3). compute the magnitude and location of the resultant force on each of the ver..

Explain what is the diameter of the copper rod : Two trains and a bird Two trains, each having a speed of 23km/h, are headed at each other on the equal straight track. A bird that can fly 60km/h flies off the front of one train when they are 70 km apart and heads directly for the other train.

Find the value of investment : An investment of $5,000 is made at interest rate of 5% compounded semi-annually.

User Account

All Pages