How to Get Folder or Select Folder In this How To, I will show you how to create a function to get folder and assign to a textbox field. I have a function given below that will return the folder name with its path. In the function below there is no parameter for the input. You can set it as a Sup Procedure like code below. Full Code: Function SelectFolder() ‘or Sub SelectFolder() Dim Fd As FileDialog Set Fd = Application.FileDialog(msoFileDialogFolderPicker) With Fd .AllowMultiSelect = False .Title =…
Read More