Hi,
I have a form with a pair of combo boxes.* The first lists subfolders within a set location (Folder1 is the root, Folder2 contains the subfolders needed to be listed.* The second combo box lists the files contained within the subfolder selected in the first combo box.* I have a command button that opens the selected file, or if no file is selected, opens the folder in windows explorer.
If the user adds a file or subfolder to the directory when the macro is already running, the new information doesn't show up in the combo box list.* The user has to close and reopen the macro to view the new information.*
I want to add a command button to force a refresh of the data in the combo boxes but can't figure out how.* I'd appreciate any suggestions anyone might have.
Please see the below code:
Bookmarks