Allow user to specify a directory via the Windows Browse Selection
<p>Specific to VBA:</p>

<p>Is it possible to ask user to specify a directory name via the standard Windows 'Browse' selection, and read that in as a variable (instead of hard-coding it in the software). </p>

<p>Such as:</p>

<pre><code>String MyStr = &lt;Inputted full path by the user via the Windows Browse Selection&gt;
</code></pre>