Answer the question
In order to leave comments, you need to log in
What to do with Overflow in VBA?
There is this code:
Private Sub CommandButton2_Click()
Dim speed As Long, minute As Long, hour As Long, day As Long
speed = 299792
minute = 60 * speed
hour = (60 * 60) * speed
day = 60 * 60 * CLng(24)
day = CLng(day) * CLng(speed)
TextBox1.Text = minute
TextBox2.Text = hour
TextBox3.Text = day
End Sub
Run-time error '6':
Overflow
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question