Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain how to copy or import VBA code to another workbook. This is great if you found code on the web, want to transfer code from one workbook to another, or import code modules to/from your Personal Macro Workbook.

Read the article and download the example file: https://www.excelcampus.com/vba/copy-import-vba-code/

Here are the 4 ways to copy VBA code or code modules between workbooks:

1. Copy and Paste VBA Code
2. Drag and Drop a Module
3. Copy Sheet Modules that contain code
4. Export/Import modules (.bas files)

I also explain how to delete or remove modules from your workbooks (VBA Projects).

Related Videos:

How to Create Your Personal Macro Workbook & Add Buttons to the Ribbon (playlist): https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

VBA Code Modules & How to Run Event Macros Based on User Actions: https://youtu.be/VJWBOuNXHB4

How to Enable the Developer Tab: https://youtu.be/JLQ8OuW0FlY

Free webinar on The 7 Steps to Getting Started with Macros & VBA: https://www.excelcampus.com/macros-webinar-yt
00:00 Introduction
01:58 Drag Drop Method
04:24 Copy to Sheet Object
05:25 Export and Import