In this video, I show you how to use standard userform components to design a "browse file" function. Although userforms do not provide a file attachment component, it is easy to create your own browse file component out of a textbox and commandbutton by making use of the Application.GetOpenFilename() method in VBA.
This interface can be used to attach a file for an email later on in a macro, open additional excel workbooks, or something else entirely.
Written tutorial: https://syntaxbytetutorials.com/excel...