I am relatively new to VBA but have some slight experience with other programming languages. I am attempting to create a user form that searches a table for data entries that meets 4 criteria. As to only tackle one issue at a time, I am just trying to get the program to print a "1" in the cells corresponding to the matching data. The code works if the criteria values are taken from a cell within the sheet and then assigned, but I cant seem to get it to work straight from the text box. That is in the following code, if I define each "SG", "ST", "SL" and "SW" through using Range("Cell").Value the code works, but if define each of these through TextBox.Value or TextBox.Text in the resulting code nothing will happen. Is their something wrong with defining terms this way? As well as is there any easier way to achieve a way of searching data with multiple criteria?
Bookmarks