SelectedItems

[Guest]

Hi All,

I'd like to use in XL2003
With Application.FileDialog(msoFileDialogFolderPicker)
.Show
to select a folder.
Pressing OK works,
.SelectedItems(1)
returns the name of the selected folder.

How can I deal with pressing Cancel? I tried

If .SelectedItems(1) = "" Then
and
If .SelectedItems(1) is Nothing Then
but with no success.

Thanks,
Stefi

 

[Guest]

Sorry again, now I know the answer:

If .Show = 0 Then


Stefi

„Stefi†ezt írta:

 

[Die_Another_Day]

if .Show = False Then 'User Clicked Cancel