title: form to open a text file for view in excel
body: <p>I'm required to create a user form like the one in the picture</p>
  
  <p><img src="https://i.stack.imgur.com/TQiqN.png" alt="enter image description here"></p>
  
  <p>I need to open a file with an extension of .txt from excel using VBA and also the button provided.</p>
  
  <p>After selecting the file, when i press start it will open the file.</p>
  
  <p>I was given some codes done by previously but was not working.</p>
  
  <p>will appreciate if someone can help me with this. Thanks!</p>
  
  <pre><code>Public Sub CommandButton1_Click()
   Unload Me 'Cancellation command
  End Sub
  
  
  Private Sub CommandButton2_Click()
  'start button
      Application.ScreenUpdating = False
  
      Sheets("Summary").Select
  
      Call Transposer("Summary Transpose")
  
      Sheets("Failing Patterns").Select
  
      Call Transposer("Failing Patterns Transpose")
  
      Me.Status = "Status: Finished"
  
      Me.Error = ""
  
      'Make sure the screen updates before the end
  
  
      Application.ScreenUpdating = True
  
  
  End Sub
  
  
  Public Sub Label1_Click()
  
  End Sub
  
  Private Sub testFinder_Click()
  
      Me.testDirectory.Value = Application.GetOpenFilename
  
  End Sub
  
  Public Sub UserForm_Click()
  
  End Sub
  </code></pre>