No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Consider the following code: Result= input_number Mod 7 If (Result > 0) Then Cells(1,1).Value = 3 Else NextResult = input_number Mod 5 If (NextResult > 0) Then Cells(1,1).Value = 2 Else Cells(1,1).Value = 1 End If End If What will be the content of cell A1 if input_number equals 56? … 
|
|
|
Consider the following VBA statement that calls a user-written function procedure Conevol with two arguments: Volume = 0.333* Module1.Conevol(radius, height) Based on the above VBA statement, identify the assertions below that are false: a. The above VBA statement resides in Module1 b. Conevol is a public procedure c. Conevol returns …
|
|
|
I'm trying to create a do while loop where I can automatically fill cells A1:D1 with the numbers 4 to 1 respectively. can anyone help??
|
|
|
How would I modify this do while loop to generate the values 4 to 1 instead of 1 to 4 I can't figure it out?!?!? thanks
|
|
|
Ok. here it is. can anyone help?? [R5] Consider the following code segment: Dim I, Isum As Integer Isum = 0 For I = 8 To 1 Step -3 Isum = Isum + I*I Next I What will the value of the variable I at the termination of the loop? …
|
|
|
VBA so that each click generates a random character between A and Z in cell A1, and the number is displayed with a random font size in the range of 16 to 24 points. can anyone help me out?? 
|