Userform; search/match two textboxes and then update that row

I have a userform that does two things, first it allows me to enter new records if I click a "new record" command button, and then it has an "update record" command button that searches all records (column B) and then updates that row with new information.
When I originally wrote the program I only wanted to search column B, which worked great, but as I worked with the outside program I learned I need to search both column B and column F, and then update which ever row is found. Here is my code that I originally used to search column B, I cannot figure out how to add F to it.

Please Login or Register  to view this content.

my first thought was to set a rng2 to find textbox8.value in range F:F and create a loop between rng1 to rng2, but i haven't been able to teach myself that.

The code is your file is not the same as the code you pasted above. I am not sure which one to edit, so I'll use the code pasted above.

Which one has priority, finding TextBox5 in column B, or finding TextBox8 in column F? I am going to assume you want to check TextBox5 first.

Please Login or Register  to view this content.

I fixed the indentation of your code, also.

Also, I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

6stringJazzeryes I tried to pare down the actual code in the paste box just so you did have 100 lines of stuff that won't change with the code to read through. I hope it wasn't too confusing.

I entered your help and it works good if there is only one entry in column B. For example if B2 is the only cell in B:B that has a value of 5 and F2 is the only cell with a value of 5, it will update row 2. if B2 and B10 both have a value of 5 the program stops and does not continue searching F:F.


Second, column F is a string variable, and as it the code does not recognize string. Values for F:F could be things like "Happy3" "treeguys24" "aaa" or "123." This is where it would be easier to define it as a variable and then set that variable to string? do I just set textbox8 to string? For now I just changed:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

and it seems to work.