FileDialog(msoFileDialogFolderPicker) question

whitedoug

New Member
Joined
Oct 7, 2009
Messages
8
This is working fine for me....

With Application.FileDialog(msoFileDialogFolderPicker)
.Show
If .SelectedItems.Count > 0 Then
Path = .SelectedItems.Item(1)
End If
End With


But when the folder picker dialog is displayed, it says "Browse" in the title bar. How do I change the title bar to say something more meaningful, like "Specify the directory for the Output File" ??

TIA
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,605
Members
412,330
Latest member
carlosjw
Top