end if cancel clicked on .FileDialog(msoFileDialogFolderPicker).Show

Good morning dedark05

Don't use the FileDialog command - use the GetopenFileName instruction instead, This allows you more control, and allows you to intercept the routine when the Cancel button has been clicked.

The self contained example below shows how it works, and how to provide feedback when cancelled.

Please Login or Register  to view this content.

HTH

DominicB

Hi there dominicb, Good evening from here in the Philippines

Thank you for helping. I'm new to VBA so please bare with me. This code is from the different people who helped me made this. I really don't know how to apply that method to my existing code.

so please check my actual file for you to test it.
https://www.dropbox.com/s/59l70ai311...v0.6.xlsm?dl=0

It's the "Select Data Source Folder Path" button.

Hi dedark05

You know when you start answering a thread without properly reading the question ...

Please Login or Register  to view this content.

The code had the bones of handling the errors there - I've just finished it off.

HTH

DominicB

Good morning dominicb,

It works! I didn't expect that only Exit Sub and Msgbox was added. Thanks you so much! I will now mark this thread as solved.

Just a few more question, how can I change ".FileDialog(msoFileDialogFolderPicker).Show" function to ".FileDialog(msoFileDialogFilePicker).Show"? I really can't make it work. I would like to select a file (.txt file) directly instead of selecting a the folder path of that file.

here is the thread
http://www.excelforum.com/showthread...t=#post4485383

I already edited it based on your code here and with some modification.