VBA INPUT box for file path with browse button

Hi,

Yes there is using FileDialog-

http://www.wiseowl.co.uk/blog/s209/type-filedialog.htm

They have an amazing Video Tutorial on their VBA Channel..

I can't put the Youtube link, as YouTube wont open at my workplace..

However the uTube channel name is - WiseOwl Tutorials > Excel VBA Introduction > Video 24

Use this code:

Sub SelectPath()
Dim path As String

With Application.FileDialog(msoFileDialogFolderPicker)
  .Title = "Select path"
  .AllowMultiSelect = False
  .Show
    If .SelectedItems.Count <> 0 Then
      path = .SelectedItems(1)
    Else
      MsgBox "Incorrect path!"
      Exit Sub
    End If
End With

MsgBox path
End Sub