Browse Dialog Box in VBA?
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 |
Browse Dialog Box in VBA?
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 |
Browse Dialog Box in VBA?
"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 |
Browse Dialog Box in VBA?
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 |
Browse Dialog Box in VBA?
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 . |
Browse Dialog Box in VBA?
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 . |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com