excel - how to find multiple criteria in vba -


Text after "div class =" itemprop = "text">

Currently searching only by the nickname of my search code, but I want to be able to search by all the boxes.

  public name Search_click () dim names string dims as the f range dims as the integer dim firstAddress string as the dim str () as the string dims ws form the worksheet form = ThisWorkbook.Worksheets ("Master") name = As the nickname. Set ws with .value f = .Range ("a: one") (find: = name, looking: = xlValues). '** Is that what I want to change ** do not have anything else with me firstname .value = f.Offset (0, 1) .Value tod.Value = f.Offset (0, 2) .Value Program.Value = f.Offset (0, 3) .value email.Value = f.Offset (0, 4). Text setcaxboxf Offset (0, 5) '& lt; & Lt; & Lt; Replace officenumber.Value = f.Offset code (0, 6) .text cellnumber.Value = f.Offset (0, 7) .text r = f.Row endnext with firstAddress = f.Address Do s = s + 1 set F = range ("A: A"). Finding x (F) while loop is not F and F. Address & lt; & Gt; First address if S & gt; 1 Then select the MsgBox (Examples of "are" in & amp; & & amp; amp;; "name, vbOKCancel or vbExclamation or vbDefaultButton1," multiple entries ") Case vbOK Case findnext vbCancel termination End of selection then: MsgBox name & amp; Set the sub  

now with the "not listed" end and end and end of f =. Range ("A: A"). Find (find: = name, look in: = XLV), but I want to search for the first name, title, area, and through which the checkbox is checked. Do I codify the same thing many times and multiply it if I can not do anything, if not then there is nothing and even after this?


Comments