I am creating a userform that will input information on to spreadsheet, all boxes/comboboxes/labels, etc have been completed/asignd and set.


I have a combobox that has values of:
Hourly
Weekly
Bi-Weekly
Monthly
Yearly

I have txtMGI which will be set to calculate based on each option
for Hourly it will take textbox a * b * 52 / 12
the formula i am using is txbMGI.Value = ((txtboxA.value * txtboxb)*52)/12
This is tied to a If statement also, but i am not sure if the Else value is needed to complete the if statement.
Here is a code sample
Private Sub txtMGI_Change()
    If cboPAYF = "Weekly" Then
        txtMGI.Value = ((txtHRRT.Value * txtHRWK.Value) * 52) / 12
    Else
        txtMGI.Value = 0#
    End If

End Sub
I am stumped on the else part and if it is needed, because i am going to have to add other if conditions to have it calculate, and so far just running the form, the txtMGI does not even update to the correct value.

Any Help would be appreciated.