WiseOwl Training - Established 1992
Protect your training budget AND save money with our new pre-payment vouchers.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 9201 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC▼

BLOGS BY AUTHOR▼

BLOGS BY YEAR▼

How to choose files and folders in VBA
Part one of a three-part series of blogs

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.

  1. Using File and Folder Dialog Boxes in VBA (this blog)
  2. File and Folder Dialog Boxes
  3. FileDialogs for Selecting Multiple Files

This blog is part of a complete Excel VBA tutorial.  Have a look also at our VBA training courses.

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:

Dialog box for choosing file

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.

 

  1. Using File and Folder Dialog Boxes in VBA (this blog)
  2. File and Folder Dialog Boxes
  3. FileDialogs for Selecting Multiple Files
This blog has 0 threads Add post