Error when userform textbox value is empty

[Prevost]

Hi,
I have a userform with 2 textboxes that a user can enter values in. When I step through the code, WOQty is "0" and WONo is "" even when the textboxes have values entered into them. I declared 'Public WOQty as Integer' and 'Public WONo as String' in my UserForm and then tried in a Module and I still get the same error. Any ideas?
Thanks!

Private Sub OK_Click()
    WOQty = Me.TextBox1.Text
    WONo = Me.TextBox2.Text
    If IsEmpty(WONo) = True Then
        MsgBox ("Please Enter A Work Order Number")
        boolrestart = True
    ElseIf IsNumeric(WOQty) = False Then
        MsgBox ("Please Enter A Numeric Quantity")
        boolrestart = True
    ElseIf IsEmpty(WOQty) = True Then
        MsgBox ("Please Enter A Work Order Quantity")
    Else
        Worksheets("Template").Unprotect Password:=""
        WOEntry.Hide
        i = 1
        SheetName = WONo & "-" & i
        Sheets("Template").Copy After:=Sheets(1)
        ActiveSheet.Name = SheetName
        Call Create_Button
        Worksheets("Template").Protect Password:=""
        Worksheets(SheetName).Unprotect Password:=""
    End If
End Sub

 

[Prevost]

And I did find this link http://www.mrexcel.com/forum/excel-questions/336856-assign-value-userorm-textbox-variable.html on MrExcel but it still doesn't seem to be working for me!

 

[mikerickson]

IsEmpty doesn't take a string as its argument. Try

IF WONo = vbNullString Then

 

[Prevost]

Thanks Mike. It still does not recognize anything that is entered in the textbox...I am not sure what is going on. I did have it working before using the code below, but I do not want the code to check for any changes in the textbox.

Private Sub TextBox1_Change()

End Sub

 

[Prevost]

Should the code posted above return a value for WONo and WOQty?