Here, you can,
Perform various actions on your Workbook. To make it easier, the Worksheet that contains most of your data will now be called the ‘Database’,
Hide the current Workbook and display the UserForm. (Watch the Video)
Open a Workbook located in the current file. (Watch the Video)
Open a Workbook located in Another file. (Watch the Video)
Save and Close the currently active Workbook. (Watch the Video)
Close all currently inactive Workbooks. (Watch the Video)
Simply, insert the requested value in the box, click on the “Get the Code” button and Hop, the code appears in the square at the very bottom of the page… copy and paste it into your UserForm…That’s it 🙂