Enforcing submit button in userform with combobox?

Excellers,

I am wondering how I can choose an item in the combobox and then press submit button rather than when I click on an item in the combobox, it executes the code immediately.

I just want to use the submit button feature. Here's the code I wrote below. I know it is missing Private Sub for the submit button. I just do not know how to write it at all. Help...?

Formula:

Private Sub Yr_Change()



    Select Case Me.Yr.Value

        Case "2012"

            MsgBox ("Hello, World!")



        Case "2013"

            MsgBox ("Whaa...?")



        Case "2014"

            MsgBox ("Howdy 2014!")



    End Select

 

End Sub



Private Sub UserForm_Initialize()



    With Me.Yr

        .AddItem "2012"

        .AddItem "2013"

        .AddItem "2014"

    End With



End Sub



Private Sub cmdCancel()

     Unload Me

End Sub