vba code to browse a folder

[szpt9m]

Hi All,

I am working on macro where in, i need to browse for a folder by clicking on browse button.

here is the code that i am using for it

Please Login or Register  to view this content.

Now when the file dialog opens to select a folder, if i click on Cancel button, the code crashes at "sItem = .SelectedItems(1)" how to fix this issue?

Please help.

Thank you.

[Norie]

Try this.

Please Login or Register  to view this content.

[szpt9m]

Thanks Norie.. It worked fine but after clicking on cancel it again pops up the file dialog and need to click on cancel one more time to close the window.