title: Using a VBA array in a SQL statement
body: <p>I am trying to write some code that uses SQL to delete rows from several tables.</p>
  
  <p>A user would type type numbers into a textbox that are separated by a comma which is used in the WHERE clause of a SQL DELETE statement.</p>
  
  <p>I have managed to split the string into a variant array and now I want to insert it into my SQL statement.</p>
  
  <p>How do I insert the variable into the SQL statement and have it run through every element of the array?</p>
  
  <p>EDIT: A bit more digging has taught me about For Each Next statements. This is probably what im looking for.</p>