BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.
- Using File and Folder Dialog Boxes in VBA (this blog)
- File and Folder Dialog Boxes
- FileDialogs for Selecting Multiple Files
Posted by Andy Brown on 13 January 2012
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Using File and Folder Dialog Boxes in VBA
Often in VBA you need to ask someone to choose a file or folder, using a dialog box like this one:
Many parts of this dialog box have been customised
This blog explains how to display a dialog box like this, how to customise it and - most importantly - how to get at the file or files selected.