FileDialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run the following code from a userform and have the
*.selecteditem value go to a textbox(s).
The user needs to identify three different directories for automation of
file saving and retrieval.

Please..... help!

************************************

With Application.FileDialog(msoFileDialogFolderPicker)
.Show


me.txt_Dir1Location.value=SelectedItems (1)


End With
 
With Application.FileDialog(msoFileDialogFolderPicker)
.Show


me.txt_Dir1Location.value= .SelectedItems(1)


End With

perhaps

You will need separate showings of the dialog - 1 per each folder you need
to select.
 
Thank you Tom!

Tom Ogilvy said:
With Application.FileDialog(msoFileDialogFolderPicker)
.Show


me.txt_Dir1Location.value= .SelectedItems(1)


End With

perhaps

You will need separate showings of the dialog - 1 per each folder you need
to select.
 
Back
Top