Pages

Friday, December 23, 2011

Display message file not selected when you click on Cancel button on file browser

If you want to display any message to the user when he clicks on "Cancel" button while selecting the file




Here is the code

Sub display_message()
Dim flpath As String
flpath = Application.GetOpenFilename("Excel File (*.xls*)," & "*xls*")

If flpath = False Then

MsgBox "You haven't selected any file", vbOKOnly
End If


End Sub

No comments:

Post a Comment