title: How to use the find funtion to search for the Value of a text box?
body: <p>I am trying to make a userform that can bring up data using an ID number.</p>
  
  <p>I am trying to reference a text box and select it, and then using it as a reference to fill out the Time and comments in the sheet. I think the is I cant put "txtID.Value" into the Find function.</p>
  
  <p>Here is an example of my code:</p>
  
  <pre><code>Sheet1.Select
  Columns("A:A").Select
  Selection.Find(What:="txtID.Value", After:=ActiveCell, LookIn:= _
  xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
  xlNext, MatchCase:=False, SearchFormat:=False).Activate
  ActiveCell.Select
  
  ActiveCell.Offset(0, 8).Value = txtTime2
  ActiveCell.Offset(0, 9).Value = txtComment2
  </code></pre>