title: Excel VBA - Workbook("") setting workbook name as a variable input from userform
body: <p>I'm wanting to set the Workbook name as a variable, which is specified by a user in the userform, txtWBName</p>
  
  <p>eg,</p>
  
  <pre><code>sWBName = userform1.txtWBName
  
  Set wb = Workbooks(" + sWBName + "): wb.Activate
  </code></pre>
  
  <p>I not quite sure how to code it, between the ""...</p>
  
  <p>Can someone please help me.
  thanks in advance.</p>