Cascading Tree Folders/Subfolders

[Janine]

Stuckagain, can someone offer a good place to start learning how to create a
tree dropdown menu for folders/subfolders in VBA please.

Many thanks for any suggestions.

 

[Doug Robbins - Word MVP]

Not really sure what you want, but the following will display a Browse
dialog and if the OK button is clicked, it will display a message box
containing the path of the selected folder:

Dim fd As FileDialog

Set fd = Application.FileDialog(msoFileDialogFolderPicker)
With fd
If .Show = CANCEL_PRESSED Then
Else
MsgBox .SelectedItems(1)
End If
End With
Set fd = Nothing


--
Hope this helps

Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.