Can't Retrieve Value from UserForm Textbox

[TheSpriceEffect]

For some reason, even when I put values of 3, 7, 11, etc into userform3 textbox2, there is always an error (always shows userform5). What am I doing wrong? Thanks in advance

Sub test()
Dim GoodNumbers(1000) As Integer

For i = 1 To 1000
GoodNumbers(i) = 3 + 4 * (i - 1)
Next i

If IsError(Application.Match(UserForm3.TextBox2.Value, GoodNumbers(), 0)) Then
UserForm5.Show
Exit Sub
End If

end sub

EDIT: I've narrowed it down to a problem pulling the value from userform3 textbox2 because when I replace that in the code with the number directly it works as intended. So why can't it read the value from this userform?

[mehmetcik]

Hi

I take it GoodNumbers is an array.

Match is to my knowledge only used in cells in a workbook.

I think that you have to loop through every entry in your array and test for a match.

So you need to either put your data into a worksheet or loop through your array.

[stnkynts]

You might want to start debugging to see where the issue is. Without a copy of your workbook that is all we will probably be able to do for you at this point:

Sub Test()
Dim GoodNumbers(1000) As Integer

'''''''''''''''''''''''''
' Testing:

Debug.Print UserForm3.TextBox2.Value
Debug.Print UserForm3.TextBox2.Text
If UserForm3.Visible = True Then
    Debug.Print "Userform3 is visible"
Else
    Debug.Print "Userform3 is not visible"
End If
''''''''''''''''''''''''''

Exit Sub

For i = 1 To 1000
GoodNumbers(i) = 3 + 4 * (i - 1)
Next i

If IsError(Application.Match(UserForm3.TextBox2.Value, GoodNumbers(), 0)) Then
UserForm5.Show
Exit Sub
End If

End Sub

[TheSpriceEffect]

Figured it out. The problem was that I had another userform with a "textbox2"