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,

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


"Raul" wrote in message
...
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" schrieb im Newsbeitrag
...
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

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" wrote in message
...
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

Thanks,
Raul


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

"Raul" schrieb im
Newsbeitrag
...
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


.

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


"Raul" wrote in
message
...
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


.