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
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?
Please Login or Register to view this content.
Last edited by TheSpriceEffect; 07-18-2014 at 01:49 PM.
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.
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:
Please Login or Register to view this content.
Figured it out. The problem was that I had another userform with a "textbox2"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks