M
Minitman
Greetings,
I am trying to get a figure in a UserForm using a CommandButton
called "Calculate". I have 7 TextBoxes. Data is entered
automatically into TB7 and TB11. TB16 is the total that I enter to
try and (break-up). TB9 and TB13 may or may not have data.
TB15 is a fudge factor to make the result come out to within a 1/4
hour. That leaves TB8 for the total time figure to be calculated.
This is what I came up with so far:
Private Sub CalculateButton_Click()
If Not TB8.Text = "" Then
TB8.Text = CStr((CDbl(TB16.Text) - CDbl(TB15.Text)) / _
(CDbl(1 + TB11)) - CDbl(TB9.Text) + _
CDbl(TB13.Text) - CDbl(TB15.Text))
End If
End Sub
Does anyone see anything even a little "hinkey"? I have gone over
this formula countless times, but I can't get it to work - HELP!!!!!!
Any help would be most appreciated
I am trying to get a figure in a UserForm using a CommandButton
called "Calculate". I have 7 TextBoxes. Data is entered
automatically into TB7 and TB11. TB16 is the total that I enter to
try and (break-up). TB9 and TB13 may or may not have data.
TB15 is a fudge factor to make the result come out to within a 1/4
hour. That leaves TB8 for the total time figure to be calculated.
This is what I came up with so far:
Private Sub CalculateButton_Click()
If Not TB8.Text = "" Then
TB8.Text = CStr((CDbl(TB16.Text) - CDbl(TB15.Text)) / _
(CDbl(1 + TB11)) - CDbl(TB9.Text) + _
CDbl(TB13.Text) - CDbl(TB15.Text))
End If
End Sub
Does anyone see anything even a little "hinkey"? I have gone over
this formula countless times, but I can't get it to work - HELP!!!!!!
Any help would be most appreciated