Thread: SelectedItems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default SelectedItems

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