Ok I figured out the random number now I just have problems with the average. I have this so far...
[CODE=vb]Average = Round(Sum / Number, 0)
Range("c1").Val ue = "Average="
Range("d1").Val ue = Average
For Count = 1 To Number
If Compare(Sheet1. Cells(Count, 1), Average) = 1 Then
Sheet1.Cells(Co unt, 5) = "The Value " & Count & "...
coreyover4
Last Activity: Sep 28 '07, 05:02 AM
Joined: Sep 5 '07
Location:
-
Also how do I right the code to average the random numbers. Is it like I know for some part its Average = Round(Sum / Number, 0), but how would I define the sum?Leave a comment:
-
I am trying that but its not working first of all and second of all I am supposed to use a while\wend loop to run the random numbers. I know I can't have yall do the work for me, I just need to know how to fix the code.Leave a comment:
-
Random Number Generator
I am trying to write a program where I ask the person to input the number of random numbers generated 1-100. Right now I am stuck on one point in particular. How do I write the program to only generate the number from the input box. I know it is probably something like adding value to the code but I am not quite sure.
This is what I have right now and it creates code 1-100. How would I change this to only generating the number instead of... -
Thanks for the help. I didnt want the whole answer, I just wanted to get pointed in the right direction on where my code was wrong and how to fix it. Thanks and I appreciate the help.Leave a comment:
-
Odd, Even
I am new just now taking classes on excel and using VB and VBA. Anyways I am having difficulties doing a code. Right now I have:
[CODE=vb]Option Explicit
Public Sub Problem4()
Dim Var1 As Long, Var2 As Long, Var3 As Long
'Input 3 numbers from user
Var1 = InputBox("Enter the first integer :", "First")
Var2 = InputBox("Enter the second integer :",...
No activity results to display
Leave a comment: