This all sounds like something better handled by formulas on a spreadsheet (hidden if necessary) that base their calculations on inputs from your userform.
You could use multiple if statements in your VBA to figure out which package is selected, then based on that, if the hours are over the amount for the selected package, take the difference and multiply by the extra value for that package and add it to the regular package value per hour to determine the MC value. It would look something like this:
If me.radA.value = True And me.txtHC.value > 10 Then
MC = Round(9.95 + ((me.txtHC.value - 10) * 2), 2)
Else
MC = Round((9.95 / 10) * me.txtHC.value, 2)
End If
If me.radB.value = True And me.txtHC.value > 20 Then
MC = Round(14.95 + ((me.txtHC.value - 20) * 1), 2)
Else
MC = Round((14.95 / 10) * me.txtHC.value, 2)
End If
If me.radC.value = True Then
MC = 19.95
End If
If the $ amounts are not hourly, and only change based on hours beyond 10 or 20, then remove the /10 and /20 from the if statements to keep the values complete until the max hours are passed.
Bookmarks