title: Create a new folder with the folder name from a text box value in Excel VB
body: <p>I want to create a new folder using an Excel VB form. When I enter a text in the textbox and click on <em>Submit</em> button it should create the folder, and the folder name must be what is entered in the textbox.</p>
  
  <p>I dont know anything about coding, just tried a code like this but it throws errors.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
    Dim Newfolder As String
    Dim path As String
    Newfolder = TextBox1.text
    path = " E:\projects\"
    ChDir (path)
    MkDir (Newfolder)
  End Sub
  </code></pre>