Minimize the VBA window and move back to Excel's main window. Click the "Macros" button located in the Code section of the Developer tab. Excel displays the Macro pop-up window.

After 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 ...

You can fix VBA Runtime Error 1004 in Excel Macro, like document not found, reference isn't valid, Paste method of worksheet class failed, etc, by following this post.

You can type codes in VBA Editor to change the cell colors in Excel. Learn how to change the cell background color with VBA Editor in Excel.