Excel VBA Tutorial 14 - Using the RefEdit Control

Use the refedit control in a user form.

[pdahnert]

At 3:22 (time in video), when you insert the form button to show the user form, Gary is actually inserting a different user form than the one he created.  Since he renamed the user form at 0:49 (time in video) to frmColorRange, you will need to write the code:
Sub Button1_Click()

    frmColorRange.Show
    
End Sub