title: How to use Input taken from the user using Input Box to replace it in the VBA
body: <p>Hi I'm writing a VBA to create few folders in the user defined path and naming it as per user.</p>
  <p>Folder structure as follows
  Folder 1&gt;&gt;&gt;Rev #</p>
  <p>First: I need to take the path from user where he wants to create a folder
  Second:  I need user to specify name for the folder, folder should be created on the same name
  Third: I need user to mention the Rev # of the folder which need to be reflected in subfolder name (Rev #)</p>
  <p>Have written the following code for the same.
  Kindly have a look and lemme know how to get the above output</p>
  <pre><code>Sub Create_Folder()
  '
  ' Create_Folder Macro
  Dim a As String
  Dim b As String
  Dim c As String
  
  '
  a = InputBox(&quot;Enter File Path&quot;, &quot;FILE PATH&quot;)
  b = InputBox(&quot;Enter File Name&quot;, &quot;FILE NAME&quot;)
  c = InputBox(&quot;Enter Rev #&quot;, &quot;REV NUMBER&quot;)
  
  Dim OriginalText As String
  Dim CorrectedText As String
  OriginaText = &quot;C:\Users\username\Desktop\Macro&quot;
  CorrectedText = Replace(OriginalText, &quot;C:\Users\username\Desktop\Macro&quot;, &quot;a&quot;)
  
  OriginaText = &quot;Folder1&quot;
  CorrectedText = Replace(OriginalText, &quot;Folder 1&quot;, &quot;b&quot;)
  
  OriginaText = &quot;Rev #&quot;
  CorrectedText = Replace(OriginalText, &quot;Rev #&quot;, &quot;c&quot;)
  
  MkDir (&quot;C:\Users\username\Desktop\Macro\Folder 1&quot;)
  MkDir (&quot;C:\Users\username\Desktop\Macro\Folder 1\Rev #&quot;)`    
  End sub
  </code></pre>