title: How to use result of input box as a worksheet name in VBA code
body: <p>I'm really new at VBA and have learned what I know so far from internet searches, but I cannot find a resolution to my issue.</p>
  
  <p>I have two workbooks, one with information on all of my company's current projects and another with just the active projects. The Active Projects workbook is where we store all the documents that need reviewing for each project. Each project has it's own worksheet.</p>
  
  <p>When I create a new worksheet in the Active Projects workbook, I would like to use a macro to fill in the relevant project information from the All Projects Workbook. </p>
  
  <p>I have seen code that copies cells and ranges from one workbook to another, but they have the sheet names hard coded in. Like this:</p>
  
  <p>'Copy range to in selected row to clipboard
    Workbooks("All Project.xlsx").Worksheets("All Open").Range("B" &amp; (ActiveCell.Row)).Copy</p>
  
  <p>'PasteSpecial to paste values, formulas, formats, etc.
    Workbooks("Active Projects.xlsm").Worksheets(<strong>InputBoxValue</strong>).Range("A2").PasteSpecial Paste:=xlPasteValues</p>
  
  <p>I thought to use an input box to ask for the worksheet name where the copied data would be pasted, but after hours of research, I cannot find out to use the result of the input box for the worksheet name.</p>
  
  <p>Thank you for furthering my VBA education</p>