Browse Dialog Box in VBA?

[Raul]

Is there a control in VBA that allows a user to browse to
a folder? If there is, can you tell me its name? I have
looked at the list of available controls in
the "Additional Controls", but did not have one jump out
at me.

Thanks,
Raul

 

[Chip Pearson]

Raul,

You have to do it with code. See
http://www.cpearson.com/excel/BrowseFolder.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Stephan Kassanke]

Is there a control in VBA that allows a user to browse to
a folder? If there is, can you tell me its name? I have
looked at the list of available controls in
the "Additional Controls", but did not have one jump out
at me.

Thanks,
Raul

Raul,

google for "vba browse folder" and you will get
http://www.developerfusion.com/show/2127/ which provides exactly what you
want.

cheers,
Stephan

 

[Bob Phillips]

Raul,

Here is an example

http://tinyurl.com/ypjkc


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Raul]

Thanks,
Raul

-----Original Message-----



Raul,

google for "vba browse folder" and you will get
http://www.developerfusion.com/show/2127/ which provides exactly what you
want.

cheers,
Stephan


.

 

[Raul]

Thanks,
Raul

-----Original Message-----
Raul,

You have to do it with code. See
http://www.cpearson.com/excel/BrowseFolder.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





.