I am not sure how to fix this problem, or even why it is a problem. I created a userform that will list the folders, sub-folders and files in a user selected directory. The user is then able to select the desired items from the list and move them into a "waiting cue" that will copy the items to a user defind destination. Right now I have this userform in a workbook that the user has to referance, and the userform is called from a button located in sheet1. In this format the userform works great.
What I would like to do is call the userform from a custom ribbon button. I have made the userform into an addin and created a custom ribbon tab with a button that calls the userform. when I click the button the userform loads but when the user attempts browse for the source files I get this error: Compile error: User-defined type not defined. I dont understand why the code fails when called from the ribbon but it works when called from a button in the spreadsheet.
I have attached spreadsheet version and the ribbon version for reference.
Thank you very much for the help.
Vendor Info Report.xlsm, Ribbon.zip
Bookmarks