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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top