Use a form in Excel to update a Macro's content..

[vonoventwin]

I have an Excel form with a textbox, 2 checkboxs (One Yes, one No) and a submit button.

When a user uses the form and clicks the Yes button and submit I want a statement added to my Sub Macro1().

This is what's in the Macro

For Each MyCell2 In Sheet1.Columns("A").Cells
                With MyCell2
                    If .Value = "" Then Exit For
                    If .Value = 574 _
                        [COLOR=Red]Or .Value = 555 _[/COLOR]
                        Or .Value = 510 Then
                        .Offset(0, 12).Value = .Offset(0, 8).Value * 1.1
                    End If
                    End With
                Next MyCell2

This is the statement I want added beneath the section in red:
Or . Value = "WHATS IN THE TEXTBOX" _

Is this possible? I have a user that doesn't know any code and trying to make it easy for them to add more values to the If statement once they encounter ones that need to be added.. Thanks!