![]() ![]() You can use these steps to export or import any Excel VBA Project object.Ĭheck out the Microsoft Excel archive, and catch up on other Excel tips. Navigate to the file you want to import. ![]() Right-click the project name in the Project-VBA Project window.Open the workbook that contains the code for your new application.To import the form into another application, follow these steps: Navigate to the folder where you want to save your form.Right-click UserForm1 in the Project Explorer.Open the workbook that contains the code you want to export.You do not need to recreate the form - simply export the code to a file that you can import later to the new application. Mary Ann Richardson explains how.Īfter creating UserForm1 for one Excel application, you realize that you’ll want to use it again (with a few modifications) in another application. You do not need to recreate the form simply export the code to a file that you can import later to the new application. Export your VBA code for use in another Excel applicationĪfter creating UserForm1 for one Excel application, you realize that you'll want to use it again - with a few modifications - in another application.
0 Comments
Leave a Reply. |